What is difference between % ROWTYPE and TYPE RECORD ?
ORACLE Interview Questions and Answers (Part 3)
(Continued from previous question...)
503. What is difference between % ROWTYPE and TYPE RECORD ?
% ROWTYPE is to be used whenever query returns a entire row of a table or view.
TYPE rec RECORD is to be used whenever query returns columns of different
table or views and variables.
E.g. TYPE r_emp is RECORD (eno emp.empno% type,ename emp ename %type
e_rec emp% ROWTYPE
cursor c1 is select empno,deptno from emp;
e_rec c1 %ROWTYPE.
(Continued on next question...)
Other Interview Questions