The %TYPE attribute provides an easy way to create a variable dependent upon a column’s data type. Using the %ROWTYPE
attribute, you can define a record that contains fields that correspond to all columns of a given table. Each field takes on the data type of its corresponding column. The fields in the record do not inherit any of the columns’ other attributes such as might be specified with the NOT NULL
clause or the DEFAULT
is a named, ordered collection of fields. A field
is similar to a variable; it has an identifier and data type, but has the additional property of belonging to a record, and must be referenced using dot notation with the record name as its qualifier.
You can use the %ROWTYPE
attribute to declare a record. The %ROWTYPE
attribute is prefixed by a table name. Each column in the named table defines an identically named field in the record with the same data type as the column.
record is an identifier assigned to the record. table
is the name of a table (or view) whose columns are to define the fields in the record. The following example shows how the emp_sal_query
procedure from the prior section can be modified to use emp%ROWTYPE
to create a record named r_emp
instead of declaring individual variables for the columns in emp