Long type column : Long « Data Type « Oracle PL / SQL






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

Long type column

  

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.








Related examples in the same category

1.Set long: query a table or view that has a LONG column
2.Change column type from long to clob
3.Demonstrate a method of converting to a LONG column to CLOB:
4.Conversion of Longs to LOBs
5.Insert char value to long type column
6.Long raw type column