Mega Code Archive

 

Categories / Oracle PLSQL / Data Type

 

Use between and with clob data

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