Record Variable Declaration
A record variable is a composite variable whose internal components, called fields, can have different data types. The value of a record variable and the values of its fields can change.
You reference an entire record variable by its name. You reference a record field with the syntax record.field.
You can create a record variable in any of these ways:
-
Define a record type and then declare a variable of that type.
-
Use
%ROWTYPEto declare a record variable that represents either a full or partial row of a database table or view. -
Use
%TYPEto declare a record variable of the same type as a previously declared record variable.
Description of the illustration record_type_definition.gif
Description of the illustration field_definition.gif
See:
record_variable_declaration ::=
Description of the illustration record_variable_declaration.gif
Name of the record type that you are defining.
Name of the field that you are defining.
Data type of the field that you are defining.
Imposes the NOT NULL constraint on the field that you are defining. For information about this constraint, see "NOT NULL Constraint".
Expression whose data type is compatible with datatype. When record_variable_declaration is elaborated, the value of expression is assigned to record.field. This value is the initial value of the field.
Name of the record variable that you are declaring.
Name of a previously defined record type. record_type is the data type of record_1.
See "%ROWTYPE Attribute".
Name of a previously declared record variable.
See "%TYPE Attribute".