Oracle’s PL/SQL questions

What is the difference between %ROWTYPE and %TYPE?

Posted by silpa on Sep 11 2007

%rowtype means associating single variable to a entire row

%type means associating single variable to a particular column in a table

advantages of %rowtype over %type
no need to know variables data type
and if column changes data type of the variable changes accordingly

TYPE rec RECORD command is to be used whenever query returns columns of different
table or views and variables.