4.1 SQL and Object Types

Oracle SQL data definition language (DDL) provides operations to support object types.

These operations include:

• Defining object types, nested tables, and arrays

• Specifying privileges

• Specifying table columns of object types

• Creating object tables

Oracle SQL DML provides the following support for object types:

• Querying and updating objects and collections

• Manipulating REFs

  See Also:

  For a complete description of Oracle SQL syntax, see Oracle Database SQL Language Reference