Mega Code Archive

 

Categories / Oracle PLSQL / Data Type

 

Use like operator with clob type data

SQL> declare   2      v1 clob := 'abc';   3  begin   4   5      If v1 like 'a%' then null; end if;   6  end;   7  / PL/SQL procedure successfully completed. SQL>