How do I search in clob field please explain me with some example.
Thanks in advance
Shailendra
Printable View
How do I search in clob field please explain me with some example.
Thanks in advance
Shailendra
Simple:
Assume the table T1 has the clob column called C1 and we want to search for the string 'shailendra'.
Code:select * from T1 where dbms_lob.instr(C1,'shailendra')>0;
Thanks julian
it is working I have two more problem can u please tell me
1) When I insert data in clob field by sql loder it is not uploding the whole file only a limited part is coming is there any problem with the file or there is some limitation of sql loder.
2) is search is casesentive in clob field?
thanks
1) Set the SQL Plus environment variables
long and longchunksize
to a higher value.
2) I think so.