how to search a string in clob??
I have the following example Table (column description is a Clob):
id title description
--------------------------
1 test this is a large
document with many
chars above 4K.
2 test2 test this is a test
select * from mytable where description like '%with%';
All the hours what i spent are not successful :-( Cause i know that
you cannot search with "like" in a clob column. :-(
Is there any way to search the data within the clob description and get all the
information back ?
I4m really new with Oracle...sorry for these kind of questions, but i say
thank you very very much for every help!!