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