Convert string to clob : CLOB « Large Objects « Oracle PL/SQL Tutorial

1. Oracle PL/SQL Tutorial
2. Large Objects
3. CLOB

SQL>
SQL> declare
  2
  3    c1 clob := to_clob('abc');
  4    c2 clob;
  5
  6  begin
  7      case c1
  8           when to_clob('abc') then dbms_output.put_line('abc');
  9           when to_clob('def') then dbms_output.put_line('def');
 10      end case;
 11
 12      c2 := case c1
 13         when to_clob('abc') then 'abc'
 14         when to_clob('def') then 'def'
 15      end;
 16
 17      dbms_output.put_line(c2);
 18
 19  end;
 20  /
abc
abc

PL/SQL procedure successfully completed.

SQL>