DEVFYI - Developer Resource - FYI

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