| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Working with a BLOB
just a guess but try ....
select dbms_lob.instr(blob_col, '.com')
from atable
where dbms_lob.instr(blob_col, '.com') between 0 an 75
-----Original Message-----
Sent: 30 May 2001 23:30
To: Multiple recipients of list ORACLE-L
I've been through the documentation on LOBs but am still stuck trying to figure out how to interrogate the contents of a BLOB.
We have a table with a BLOB column in it. All it contains in text data (i.e. memo notes). Why it was created as a BLOB and not a CLOB is unknown to me and done before I was hired. All I need to do is determine if a particular string ('.com') pattern exists in the column, within the first 75 bytes, and return its starting position.
Would someone help me out? Thanks!
-w
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Walter K INET: alden14004_at_yahoo.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-LReceived on Thu May 31 2001 - 04:52:48 CDT
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing). _____________________________________________________________________ This message has been checked for all known viruses by Star Internet delivered through the MessageLabs Virus Scanning Service. For further information visit http://www.star.net.uk/stats.asp or alternatively call 01285 884400. This message is intended only for the use of the person(s) (the "intended recipient
(s)") to whom it is addressed.
It may contain information which is privileged and confidential. If you are not the intended recipient, please contact the sender as soon as possible. The views expressed in this communication may not necessarily be the views of InterX plc. Any copyright in this message shall remain vested in InterX plc © and the intended recipient may only copy the same for internal business purposes or as otherwise stated in this message. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vipul Lakhani INET: VLakhani_at_interx.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).
 |
 |