03 July 2015

A simple way of SELECTing values from a comma-separated string

See my later blog post "An updated and better method for selecting values from a string using the APEX_STRING packagefor an updated and better way of doing this 

Want a quick and easy way to select from a comma-separated list? Just use xmltable. 


This can be used for a FOR loop too! 



Note: You probably shouldn't use this in an environment that requires high-performance though.  As Mathias Rogel and Carsten Czarski have pointed out here, it's not as efficient as a PL/SQL-pipelined function or a pure SQL-approach - but it does have the merit of being simple.

1 comment:

  1. This article is loaded with some well-informed data. You have made admirable statements in an exceptional manner about this article. Since this has made me wonder about more things I would want to know about chartered professional accountants of ontario

    ReplyDelete