The only way I can think of doing this in sql would involve a bunch of INSTR() and SUBSTR() functions and hardcoded repetitions, and would get ugly fast. Go with pl/sql, it would be a snap to assemble the result set there.
Lisa
-----Original Message-----
From: OraCop [SMTP:[EMAIL PROTECTED]]
Sent: Monday, December 09, 2002 4:00 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Parsing Column val
Yes there is primary key on the table.
--- "Koivu, Lisa" <[EMAIL PROTECTED]> wrote:
> Looks to me like you have to do this in pl/sql
> unless you can say something
> about the uniqueness of col1 and col2. Is there a
> primary key on the table?
>
> Lisa Koivu
> Oracle Diaper Administrator
> Fairfield Resorts, Inc.
> 5259 Coconut Creek Parkway
> Ft. Lauderdale, FL, USA 33063
>
>
>
> > -----Original Message-----
> > From: OraCop [SMTP:[EMAIL PROTECTED]]
> > Sent: Monday, December 09, 2002 1:24 PM
> > To: Multiple recipients of list ORACLE-L
> > Subject: Parsing Column val
> >
> > Hello,
> > One of the column in EACH row has space saperated
> > values.
> >
> > Example
> >
> > Col1 Col2 Col3
> > ==============================
> > Hello World he she we
> > oracle rules any doubt
> >
> > Out put should look like
> >
> >
> > Col1 Col2 Col3
> > ==============================
> > Hello World he
> > Hello World she
> > Hello World we
> > Oracle rules any
> > Oracle rules doubt
> >
> >
> >
> > Please Help.
> >
> > URGENT!
> >
> > Thanks.
> >
> > __________________________________________________
> > Do you Yahoo!?
> > Yahoo! Mail Plus - Powerful. Affordable. Sign up
> now.
> > http://mailplus.yahoo.com
> > --
> > Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> > --
> > Author: OraCop
> > INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services -- 858-538-5051
> http://www.fatcity.com
> > San Diego, California -- Mailing list and
> web hosting services
> >
>
---------------------------------------------------------------------
> > To REMOVE yourself from this mailing list, send an
> E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of
> 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB
> ORACLE-L
> > (or the name of mailing list you want to be
> removed from). You may
> > also send the HELP command for other information
> (like subscribing).
>
__________________________________________________
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: OraCop
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
