Ispirer Website Ispirer Capabilities - Oracle Migration Free Trial

PL/SQL Records

PL/SQL record is a group of fields, each with own name and data type, similar to the columns in a table row. You can use a record variable to store a table row, or some columns from a table row.

The %ROWTYPE attribute lets you declare a PL/SQL record that represents a row in a table, without listing all the columns. You can also declare a cursor to select specific columns, and then apply %ROWTYPE to the cursor.

Declaring PL/SQL Record

Before you can use a record variable, you need to define RECORD type and then declare a variable of that type. You can specify a NOT NULL constraint or default values. You can use %TYPE to specify a field type corresponding to a table column type.

TYPE empRecType IS RECORD ( 
    id NUMBER(4),
    name VARCHAR2(100),
    dept_id NUMBER(4)
emp_rec empRecTyp; 

You do not need to define a RECORD type if you create a record variable using %ROWTYPE% attribute

emp_rec employees%ROWTYPE%;

Assigning Values to Records

You can assign a value to a record field using an assignment statement with dot notation: := 'John';

© 1999-2023, Ispirer Systems, LLC. All Rights Reserved.