On Thu, Aug 16, 2001 at 02:15:55AM -0800, Guy Hammond wrote:
I have another CLOB question, what is the best way to do a
search-and-replace?
Something like a c/oldvalue/newvvalue/ on the SQL*Plus command line, or
$variable =~ s/oldvalue/newvalue/; in Perl.
The only thing I can think of
Bill,
How about
select id
from MyTable
where DBMS_LOB.INSTR(YourClobColumn,UPPER(value_to_search_for)) 0
and your_db_version = 8i
HTH
Raj
__
Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion
will always do what you
tell it to do, but rarely what you want it to do.
- -Original Message-
- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Jamadagni,
- Rajendra
- Sent: Wednesday, August 15, 2001 3:35 PM
- To: Multiple recipients of list ORACLE-L
- Subject: RE: CLOB field