Long type column, not null : LONG « Large Objects « Oracle PL/SQL Tutorial






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.








34.6.LONG
34.6.1.long type column
34.6.2.Long raw type column
34.6.3.Long type column, not null
34.6.4.Copying LONG to LOB with the ALTER TABLE...MODIFY statement