%ROWTYPE Attribute

Syntax

rowtype_attribute ::=

Semantics

explicit_cursor_name

Name of an explicit cursor. For every column selected by the query associated with explicit_cursor_name, the record has a field with the same name and data type.

cursor_variable_name

Name of a strong cursor variable. For every column selected by the query associated with cursor_variable_name, the record has a field with the same name and data type.

db_table_or_view_name

Name of a database table or view that is accessible when the declaration is elaborated. For every column of db_table_or_view_name, the record has a field with the same name and data type.

Examples

• Example 5-38, "%ROWTYPE Variable Represents Full Database Table Row"

• Example 5-39, "%ROWTYPE Variable Does Not Inherit Initial Values or Constraints"

• Example 5-40, "%ROWTYPE Variable Represents Partial Database Table Row"

• Example 5-41, "%ROWTYPE Variable Represents Join Row"

• Example 5-45, "Assigning %ROWTYPE Record to RECORD Type Record"

Related Topics

In this chapter:

• "Cursor Variable Declaration"

• "Explicit Cursor Declaration and Definition"

• "Record Variable Declaration"

• "%TYPE Attribute"

In other chapters:

• "%ROWTYPE Attribute"