I need to know the difference between using like operator or DBMS_LOB.INSTR for an CLOB column. I need to know which one is better and efficient in processing
from user_notes where lower(description) like '%abd%'
From user_notes where DBMS_LOB.INSTR(lower(description),'abc') >0;
Here description is an CLOB column