Mega Code Archive
Convert string to clob
<![CDATA[
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>
]]>