|Oracle® Database PL/SQL Language Reference
11g Release 1 (11.1)
|PDF · Mobi · ePub|
%ROWTYPE attribute lets you declare a record that represents a row in a table or view. For each column in the referenced table or view, the record has a field with the same name and data type. To reference a field in the record, use
field_name. The record fields do not inherit the constraints or default values of the corresponding columns.
If the referenced item table or view changes, your declaration is automatically updated. You need not change your code when, for example, columns are added or dropped from the table or view.
An explicit cursor previously declared within the current scope.
A PL/SQL strongly typed cursor variable, previously declared within the current scope.
A database table or view that must be accessible when the declaration is elaborated.