Three Ways to Create a Table Containing a BFILE

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

Text description of the illustration adl12b19.gif

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 Creating a Table Containing One or More BFILE Columns

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

3. Contained within a nested table -- see Creating 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.