Three Ways to Create a Table Containing a LOB

Figure 9-3 Use Case Diagram: Four ways to Create a Table Containing a LOB

See: "Use Case Model: Internal Persistent LOBs Basic Operations", for all basic operations of Internal Persistent LOBs.

It is possible to incorporate LOBs into tables in three ways.

1. As columns in a table -- see CREATE a Table Containing One or More LOB Columns.

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

3. Within a nested table -- see CREATE a Nested Table Containing a LOB.

A fourth method using a Varray -- Creating a Varray Containing References to LOBs is described in Chapter 5, "Advanced Topics" .

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