PL/SQL Cursor Based Records

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
You can use the %ROWTYPE with an explicit cursor or cursor variable where each field corresponds to a column or aliased expression in the cursor SELECT statement.
In the below example, a record is declared with the same structure as an explicit cursor:
DECLARE
 CURSOR Books_Cursor IS
  SELECT * FROM books
  WHERE author LIKE '%john%';
my_book_cur_rec Books_Cursor%ROWTYPE;

Example 2 of Cursor Based Records
Cursor emp_cur is
Select ename, eno. , hiredate
From emp;
emp_rec emp_cur%ROWTYPE

Example 3 of Cursor Based Records
CURSOR c IS
SELECT beer, price
FROM Sells
WHERE bar = 'Joe''s bar';
Bp1 c%ROWTYPE;

Posted in: PL/SQL tutorial pdf