Use to_clob with case when statement : TO_CLOB « Data Type « Oracle PL / SQL






Use to_clob with case when statement

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

PL/SQL procedure successfully completed.

SQL>

   
  








Related examples in the same category

1.TO_CLOB(x): Converts x to a character large object (CLOB). A CLOB is used to store large amounts of character data