Oracle-L: RE: SQL Question

From: Deshpande, Kirti <kirti.deshpande_at_verizon.com>
Date: Wed, 29 May 2002 11:09:17 -0800
Message-ID: <F001.0046E8D4.20020529110917@fatcity.com>

Thanks.
Substr/instr was rejected because it was a bit difficult to read the code.

Also, they wanted to extract the fields in their own column headings (new requirement). So 'replace' may not fly much !!

Kirti

-----Original Message-----
Sent: Wednesday, May 29, 2002 1:45 PM
To: Multiple recipients of list ORACLE-L

What about

select commission_id, replace(com_text_msg,'~',chr(9)) from tab1

which would work if going to a tab separated file for something like excel.

Whats wrong with substr/instr?

Iain Nicoll

-----Original Message-----
Sent: Wednesday, May 29, 2002 7:22 PM
To: Multiple recipients of list ORACLE-L

I need some help...

The database table has following structure. commision_id number
com_text_msg varchar2(500)

The second column contains data fields that are delimited by ~ and delimiter's position varies. But there are only eight data fields in the column.

Is there a way in SQL, other than substr/instr combinations, to extract each data field to report?

Thanks.

Kirti

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Deshpande, Kirti
INET: kirti.deshpande_at_verizon.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

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: Nicoll, Iain (Calanais)
INET: iain.nicoll_at_calanais.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

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: Deshpande, Kirti
INET: kirti.deshpande_at_verizon.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------