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).
