RE: Parsing Column val

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:oracop_at_yahoo.com]
> 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" <Lisa.Koivu_at_efairfield.com> 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:oracop_at_yahoo.com]
> > > 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: oracop_at_yahoo.com
> > >
> > > 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: ListGuru_at_fatcity.com (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: oracop_at_yahoo.com
>
> 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: ListGuru_at_fatcity.com (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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Koivu, Lisa
  INET: Lisa.Koivu_at_efairfield.com

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: ListGuru_at_fatcity.com (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).