Record Variables : RECORD « PL SQL Data Types « Oracle PL/SQL Tutorial

1. Oracle PL/SQL Tutorial
2. PL SQL Data Types
3. RECORD

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>