output will be written to a 2nd table and I may/may
not have primary key on that table.
Thanks.
- OraCop <oracop_at_yahoo.com> wrote:
> 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).
>
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).
Received on Mon Dec 09 2002 - 16:08:51 CST