PL/SQL Cursor Based Records

Cursor-Based record has fields that match in name, datatype, and order to the final list of columns in the cursor’s SELECT statement.

Example 1 of Cursor Based Records

Cursor emp_cur is
Select ename, eno. , hiredate
From emp;

emp_rec emp_cur%ROWTYPE

Example 2 of Cursor Based Records

CURSOR c IS
SELECT beer, price
FROM Sells
WHERE bar = 'Joe''s bar';

Bp1 c%ROWTYPE;