Search on a CLOB column on Oracle DB

Hi,

You can user instr function for searching on a CLOB column.

Ex:

select * from TABLE_NAME where instr(COLUMN_NAME,'SEARCH PARAM') > 0 order by process_date desc

Have a nice day!