Table_RowType1.htm
 
--set serveroutput on;
-- table based
-- record_rowtype1.sql
DECLARE
emp_rec1 emp%rowtype;
BEGIN
SELECT * into emp_rec1
FROM emp WHERE empno = 7521;
dbms_output.put_line('emp ID: ' || emp_rec1.empno);
dbms_output.put_line('emp Name: ' || emp_rec1.ename);
dbms_output.put_line('emp job: ' || emp_rec1.job);
dbms_output.put_line('emp deptno: ' || emp_rec1.deptno);
dbms_output.put_line('emp mgr: ' || emp_rec1.mgr);
END;
/