%TYPE Attribute

The %TYPE attribute lets you declare a constant, variable, collection element, record field, or subprogram parameter to be of the same data type as a previously declared variable or column (without knowing what that type is). The item declared with %TYPE is the referencing item, and the previously declared item is the referenced item.

The referencing item inherits the following from the referenced item:

• Data type and size

• Constraints (unless the referenced item is a column)

The referencing item does not inherit the initial value of the referenced item.

If the declaration of the referenced item changes, then the declaration of the referencing item changes accordingly.

LNPLS1853Topics

• Syntax

• Semantics

• Examples

• Related Topics

Syntax

LNPLS1350type_attribute ::=

Description of the illustration type_attribute.gif

Semantics

LNPLS1351collection_variable

Name of a collection variable.

LNPLS1854Restriction on collection_variable  In a constant declaration, collection_variable cannot be an associative array variable.

LNPLS1352cursor_variable

Name of a cursor variable.

LNPLS1353db_table_or_view

Name of a database table or view that is accessible when the declaration is elaborated.

LNPLS1855column

Name of a column of db_table_or_view.

LNPLS1354object

Name of an instance of an ADT.

LNPLS1355record_variable

Name of a record variable.

LNPLS1356field

Name of a field of record_variable.

LNPLS1357scalar_variable

Name of a scalar variable.

Examples

• Example 2-15, "Declaring Variable of Same Type as Column"

• Example 2-16, "Declaring Variable of Same Type as Another Variable"

Related Topics

LNPLS1856In this chapter:

• "Constant Declaration"

• "%ROWTYPE Attribute"

• "Scalar Variable Declaration"

LNPLS1857In other chapters:

• "%TYPE Attribute"