How to search a string in clob field?

[shailendra]

How do I search in clob field please explain me with some example.


Thanks in advance
Shailendra

[julian]

Simple:

Assume the table T1 has the clob column called C1 and we want to search for the string 'shailendra'.

select * from T1 where dbms_lob.instr(C1,'shailendra')>0;

[shailendra]

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

[julian]

1) Set the SQL Plus environment variables

long and longchunksize

to a higher value.

2) I think so.