Convert string to clob : CHAR « Data Type « Oracle PL / SQL






  1. Oracle PL / SQL
  2. Data Type
  3. CHAR

Convert string to 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>








Related examples in the same category

1.The CHAR data type is used for storing fixed-length character strings.
2.char type with 50 characters
3.Define varchar2 type variable
4.Comparison of CHAR with VARCHAR2
5.Define and use char value
6.set column width by setting char number
7.CHAR() and VARCHAR2()
8.'' represents a zero length character string BUT NOT a null value
9.No equality comparison between two '' strings
10.Compare char value without knowing the case
11.char type and varchar2 type
12.Memory allocation differences between the CHAR and VARCHAR2 datatypes