Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: inserting comma-separated values with pl/sql

Re: inserting comma-separated values with pl/sql

From: DA Morgan <damorgan_at_exesolutions.com>
Date: Sat, 22 Feb 2003 13:01:53 -0800
Message-ID: <3E57E541.5B6629D2@exesolutions.com>


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.

>

> Hu, how can one find this out since the package is obfuscated (at least in
> my ora 9i)?!

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US