hi,
if you are looking for a code which searches text from a CLOB datatype,
heres what you can do.
say for eg. you have to search for the string "test" in the clob column
col_clob

select instr(to_char(col_clob),'test',1,1) into <var> from dual

this will give you the position of the first occurance of "test" in the
col_clob column starting from left.
in case it is not there, it will return 0 in the variable <var>

hope this helps.
thanx.
Trupti

-----Original Message-----
From: Sreedhar_Bhaskararaju
[mailto:oracledba-ezmlmshield-x11616254.[Email address protected]
Sent: Wednesday, November 30, 2005 6:32 PM
To: LazyDBA Discussion
Subject: Searching in CLOB datatype


Hi All,



Can any body give searching procedure for a clob datatype?



Thanks in advance,

Sree



DISCLAIMER:
This email (including any attachments) is intended for the sole use of the
intended recipient/s and may contain material that is CONFIDENTIAL AND
PRIVATE COMPANY INFORMATION. Any review or reliance by others or copying or
distribution or forwarding of any or all of the contents in this message is
STRICTLY PROHIBITED. If you are not the intended recipient, please contact
the sender by email and delete all copies; your cooperation in this regard
is appreciated.


--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html


Oracle LazyDBA home page