Copying LONG to LOB with the ALTER TABLE...MODIFY statement : LONG « Large Objects « Oracle PL/SQL Tutorial

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

SQL> CREATE TABLE myLongTable1 (id NUMBER,long_data LONG);

Table created.

SQL>
SQL> INSERT INTO myLongTable1 VALUES (100,RPAD('A',200000,'A'));

1 row created.

SQL>
SQL> ALTER TABLE myLongTable1 MODIFY (long_data CLOB);

Table altered.

SQL>
SQL> drop table myLongTable1;

Table dropped.