RecordDemo.sql

-- This is were you declare variables that will be needed.
 
DECLARE
 
-- declare a record type with two fields to select the rows you wish 
 
-- to retrive the %TYPE attribute declare a variable which will
 
-- use the default data type of the column in the table 
 
 TYPE emp_rec_type IS RECORD (empno emp.empno%TYPE,ename emp.ename%TYPE);
 
 
-- declare a record that will hold the rows retrieved from the table.   
   emp_rec emp_rec_type;
 
-- start the loop with the keyword BEGIN
   BEGIN
 
   LOOP
 
-- select the rows you want to manipulate
   SELECT empno,ename
 
-- The rows selected will be put into the emp_rec record
   INTO emp_rec
 
-- specify the table where the data is being retrived from
   FROM emp;
 
-- merge the two fields and print out the results 
   DBMS_OUTPUT.PUT_LINE(emp_rec.empno