Thursday, September 17, 2009

Oracle Tip: Create functions to join and split strings in SQL

Oracle Tip: Create functions to join and split strings in SQL: "A common task when selecting data from a database is to take a set of values a query returns and format it as a comma delimited list. Another task that's almost as common is the need to do the reverse: Take a comma delimited list of values in a single string and use it as a table of values."