You can use below SQL query to search a string in CLOB object stored in database,
select * from tablename where dbms_lob.instr(clob column name , ‘search string’ )>0;
Post your questions and share knowledge, Hopefully you will gain something of significance here
You can use below SQL query to search a string in CLOB object stored in database,
select * from tablename where dbms_lob.instr(clob column name , ‘search string’ )>0;