Oracle® Database PL/SQL Language Reference 11g Release 2 (11.2) Part Number E25519-05 |
|
|
PDF · Mobi · ePub |
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 %ROWTYPE
to declare a record variable that represents either a full or partial row of a database table or view.
Use %TYPE
to declare a record variable of the same type as a previously declared record variable.
LNPLS1780Topics
LNPLS1288record_type_definition ::=
LNPLS1289field_definition ::=
See:
LNPLS1290record_variable_declaration ::=
LNPLS1781record_type_definition
LNPLS1782record_type
Name of the record type that you are defining.
LNPLS1783field_definition
LNPLS1784field
Name of the field that you are defining.
LNPLS1785datatype
Data type of the field that you are defining.
LNPLS1786NOT NULL
Imposes the NOT
NULL
constraint on the field that you are defining. For information about this constraint, see "NOT NULL Constraint".
LNPLS1787expression
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.
LNPLS1788record_variable_declaration
LNPLS1789record_1
Name of the record variable that you are declaring.
LNPLS1790record_type
Name of a previously defined record type. record_type
is the data type of record_1
.
LNPLS1791rowtype_attribute
See "%ROWTYPE Attribute".
LNPLS1792record_2
Name of a previously declared record variable.
LNPLS1793%TYPE
See "%TYPE Attribute".
Example 5-34, "RECORD Type Definition and Variable Declarations"
Example 5-35, "RECORD Type with RECORD Field (Nested Record)"
LNPLS1794In this chapter:
LNPLS1795In other chapters: