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






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>








34.3.BLOB
34.3.1.Creating Tables Containing BLOB Objects
34.3.2.Initialize BLOB column data
34.3.3.Adding Content to a BLOB
34.3.4.Use update statement to change the value in blob type column
34.3.5.UPDATE sets blob_column to a binary number:
34.3.6.Open the BLOB
34.3.7.Loading a page to a BLOB
34.3.8.Populating a BLOB column from an external BFILE
34.3.9.INSERT a row with an empty blob
34.3.10.Display the length of the BLOB
34.3.11.Obtain length of the populated BLOB
34.3.12.Close the BLOB