Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: inserting comma-separated values with pl/sql
Christoph Seidel wrote:
> DA Morgan wrote:
> > 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.
>
http://tahiti.oracle.com
http://asktom.oracle.com
take a class
read a book
Daniel Morgan Received on Sat Feb 22 2003 - 15:01:53 CST