Re: inserting comma-separated values with pl/sql

From: DA Morgan <damorgan_at_exesolutions.com>
Date: Sat, 22 Feb 2003 11:21:14 -0800
Message-ID: <3E57CDA9.6AEA104@exesolutions.com>

Christoph Seidel wrote:

> Christoph Seidel wrote:
> > DA Morgan wrote:
> >> Kenneth and Karsten's responses are good general methods. If your
> >> comma delimited values are no more than 30 characters,
> >> DBMS_UTILITY.COMMA_TO_TABLE is far more efficient.
> >
> > well, really great tip! thanx alot!
>
> oops, not a great tip :) does not work with numbers, i think with "list of
> names" the docs mean list of object names in the data dictionary!?

Works with numbers ... you just need to use REPLACE to replace the commas with "," (double quote comma double quote) and concatenate double quotes at the beginning and end of the string.

Even with this minor amount of overhead it blows away SUBSTR/INSTR methods every time I ever tested with DBMS_PROFILER.

Daniel Morgan Received on Sat Feb 22 2003 - 13:21:14 CST