CODE EXAMPLE FOR SQL

where clause for clob in oracle

select * 
    from aTable 
   	where dbms_lob.compare(aClobColumn, 'value') = 0 //implicitly converting value to clob datatype
   
//for explicitly converting 'value' to clob data type.
  select * 
    from aTable 
   	where dbms_lob.compare(aClobColumn, to_clob('value')) = 0
//both does the same thing