21. 30. 6. Record Variables |
|
A record is a collection of individual fields that represents a row in a table. |
These fields are unique and each has its own values. |
By using records, you can group like data into one structure and then manipulate this structure as one entity or logical unit. |
You declare a record in the declaration portion of a PL/SQL block, subprogram, or package. |
SQL>
SQL>
SQL> DECLARE
2 TYPE hrc_company_rec IS RECORD
3 (hrc_company_id NUMBER,
4 product_description VARCHAR2(20),
5 company_short_name VARCHAR2(30));
6 v_example_rec hrc_company_rec;
7 BEGIN
8 /*Do some processing */
9 null;
10 END;
11 /
PL/SQL procedure successfully completed.
SQL>
SQL>
|
|