Call to_lob to convert long to clob : TO_LOB « Large Objects « Oracle PL/SQL Tutorial

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

SQL>
SQL> create table long_table
  2  ( id         int primary key,
  3    data       long
  4  )
  5  /

Table created.

SQL> create table clob_table as select id, to_lob(data) data from long_table;

Table created.

SQL>
SQL> insert into clob_table select id, to_lob(data) from long_table;

0 rows created.

SQL>
SQL> begin
  2      insert into clob_table select id, to_lob(data) from long_table;
  3  end;
  4  /

PL/SQL procedure successfully completed.

SQL>
SQL> drop table clob_table;

Table dropped.

SQL>
SQL> drop table long_table;

Table dropped.