Three Ways to Create a Table Containing a BFILE

Figure 11-2 Use Case Diagram: Three Ways to Create a Table Containing One or More BFILE Columns

See Also: "Use Case Model: External LOBs (BFILEs)" for all basic operations of External LOBs (BFILES).

You can incorporate BFILEs into tables in the following three ways:

1. As columns in a table -- see CREATE a Table of an Object Type with a BFILE Attribute

2. As attributes of an object type -- see CREATE a Table of an Object Type with a BFILE Attribute

3. Contained within a nested table -- see CREATE a Table with a Nested Table Containing a BFILE

In all cases SQL Data Definition Language (DDL) is used -- to define BFILE columns in a table and BFILE attributes in an object type.