Oracle and PL/SQL Recipes: A Problem-Solution Approach

10-3. Creating Simple Records

Problem

You need a PL/SQL data structure to group related employee data to make manipulating the group easier.

Solution

Define a record structure of the related employee data, and then create a variable to hold the record structure. In this example, a simple RECORD structure is defined and initialized.

DECLARE TYPE    rec_type IS RECORD (                 last_name       varchar2(25),                 department      varchar2(30),                 salary          number ); rec     rec_type; begin    rec.last_name        := 'Juno';    rec.department       := 'IT';    rec.salary           := '5000'; END;

How It Works

Record structures are created in PL/SQL by using the TYPE statement along with a RECORD structure ...