Creating Tables Containing BLOB Objects : BLOB « Large Objects « Oracle PL/SQL Tutorial

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

SQL>
SQL> CREATE TABLE myTable (
  2    id          INTEGER PRIMARY KEY,
  3    blob_column BLOB NOT NULL
  4  );

Table created.

SQL>
SQL> desc myTable;
 Name               Null?    Type
 ---------------
 ID                 NOT NULL NUMBER(38)
 BLOB_COLUMN        NOT NULL BLOB

SQL>
SQL> drop table myTable;

Table dropped.

SQL>