RE: Parsing a BLOB

From: John Flack <JohnF_at_smdi.com>
Date: Thu, 19 Feb 2004 12:10:56 -0500
Message-ID: <91AFBA9B76078B4E8340A383EADEF1DBBC4F22@syn2kex1.smdi.com>

That is nice to know, and will help if I decide to write the parsing = code myself. However, I was hoping for something with less work. Like = can I make the BLOB the data source for an external table, without first = writing it to a file on the server?

-----Original Message-----
From: Powell, Mark D [mailto:mark.powell_at_eds.com] Sent: Thursday, February 19, 2004 11:24 AM To: 'oracle-l_at_freelists.org'
Subject: RE: Parsing a BLOB

If you are on version 9+ the character functions: substr, instr, etc... = were
enhanced to be able to work directly on CLOB's so resorting to dbms_lob.substr is unnecessary.

>> string can be any of the datatypes CHAR, VARCHAR2, NCHAR, NVARCHAR2,
CLOB, or NCLOB. << From SQL Manual 9.2

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Jamadagni, Rajendra Sent: Thursday, February 19, 2004 10:45 AM To: oracle-l_at_freelists.org
Subject: RE: Parsing a BLOB

if it is TEXT, why can't you use CLOB?? Why BLOB??

If it is a column, then use dbms_lob subprograms to manipulate the =3D contents ... it will be much easier that way.

Raj

---

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

---

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Thu Feb 19 2004 - 11:10:56 CST