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; / |