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






  1. Oracle PL/SQL Tutorial
  2. Large Objects
  3. BFILE
SQL>
SQL> CREATE TABLE myTable (
  2    id           INTEGER PRIMARY KEY,
  3    bfile_column BFILE NOT NULL
  4  );

Table created.

SQL>
SQL> desc myTable;
 Name            Null?    Type
 ---------------
 ID              NOT NULL NUMBER(38)
 BFILE_COLUMN    NOT NULL BINARY FILE LOB

SQL>
SQL> drop table myTable;

Table dropped.








34.2.BFILE
34.2.1.Creating Tables Containing BFILE Objects
34.2.2.Populating a BFILE Column with a Pointer to a File
34.2.3.Populating BFILE
34.2.4.BFILE type column
34.2.5.BFILE value and BFILENAME function
34.2.6.BFILE column and directory
34.2.7.Create a BFILE locator
34.2.8.Retrieve the LOB locater
34.2.9.Use a BFILE to load a LOB column