RE: Parsing a BLOB

From: Powell, Mark D <mark.powell_at_eds.com>
Date: Thu, 19 Feb 2004 11:24:20 -0500
Message-ID: <564DE4477544D411AD2C00508BDF0B6A1CE0A9FE@USAHM018.amer.corp.eds.com>

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 = contents ... it will be much easier that way.

Raj

-------------------------------------------------------------------------=

---

Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. select standard_disclaimer from company_requirements; QOTD: Any clod can have facts, having an opinion is an art !

---

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
-----------------------------------------------------------------
----------------------------------------------------------------
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 - 10:24:20 CST