2017  Kodetalk | Feedback | Privacy Policy | Terms | About
userimage

difference between % ROWTYPE and TYPE RECORD ?

What is difference between % ROWTYPE and TYPE RECORD ?

 

userimage

%  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.     

Eg  for type: TYPE  t1  IS RECORD (Name Varchar2,No Number);

Eg for %  ROWTYPE : a emp%rowtype;

Answer is