Oracle PL/SQL Tutorial/Large Objects/LONG

Copying LONG to LOB with the ALTER TABLE...MODIFY statement

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.

Long raw type column

SQL> CREATE TABLE myTable (
  2    id              INTEGER PRIMARY KEY,
  3    long_raw_column LONG RAW NOT NULL
  4  );
Table created.
SQL>
SQL> drop table myTable;
Table dropped.

long type column

SQL>
SQL> CREATE TABLE myLongTable (id NUMBER,long_data LONG);
Table created.
SQL>
SQL> INSERT INTO myLongTable VALUES (100,RPAD("A",200000,"A"));
1 row created.
SQL>
SQL> drop table myLongTable;
Table dropped.
SQL>

Long type column, not null

SQL> CREATE TABLE myTable (
  2    id          INTEGER PRIMARY KEY,
  3    long_column LONG NOT NULL
  4  );
Table created.
SQL>
SQL>
SQL> drop table myTable;
Table dropped.