In() function with clob data
SQL> declare 2 v1 clob := 'abc'; 3 begin 4 5 If 'abc' IN (v1) then null; end if; 6 end; 7 / PL/SQL procedure successfully completed. SQL>