Return-Path: Received: from ensim.rackshack.net (root@localhost) by orafaq.net (8.11.6/8.11.6) with ESMTP id gBA2Di513557 for ; Mon, 9 Dec 2002 20:13:44 -0600 X-ClientAddr: 209.68.248.164 Received: from newsfeed.cts.com (newsfeed.cts.com [209.68.248.164]) by ensim.rackshack.net (8.11.6/8.11.6) with ESMTP id gBA2Di313552 for ; Mon, 9 Dec 2002 20:13:44 -0600 Received: from fatcity.UUCP (uucp@localhost) by newsfeed.cts.com (8.9.3/8.9.3) with UUCP id OAA21484; Mon, 9 Dec 2002 14:56:22 -0800 (PST) Received: by fatcity.com (26-Feb-2001/v1.0g-b72/bab) via UUCP id 00515AB3; Mon, 09 Dec 2002 14:04:29 -0800 Message-ID: Date: Mon, 09 Dec 2002 14:04:29 -0800 To: Multiple recipients of list ORACLE-L X-Comment: Oracle RDBMS Community Forum X-Sender: "Koivu, Lisa" Sender: root@fatcity.com Reply-To: ORACLE-L@fatcity.com Errors-To: ML-ERRORS@fatcity.com From: "Koivu, Lisa" Subject: RE: Parsing Column val Organization: Fat City Network Services, San Diego, California X-ListServer: v1.0g, build 72; ListGuru (c) 1996-2001 Bruce A. Bergman Precedence: bulk Mime-Version: 1.0 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C29FCE.2A58B211" ------_=_NextPart_001_01C29FCE.2A58B211 Content-Type: text/plain 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@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" 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@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@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@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@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@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). ------_=_NextPart_001_01C29FCE.2A58B211 Content-Type: text/html Content-Transfer-Encoding: quoted-printable 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@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@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@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
    > >   = =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D
    > >   = Hello       World    he = she we
    > >   = oracle      rules     any = doubt
    > >
    > > Out put should look = like
    > >
    > >
    > >   = Col1       = Col2      Col3
    > >   = =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D
    > >   = 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@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@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@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@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).

------_=_NextPart_001_01C29FCE.2A58B211-- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Koivu, Lisa INET: Lisa.Koivu@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@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).