% ROWTYPE is used when a query returns an entire row of a table or view.TYPE RECORD, on the other hand, is used when a query returns column of different tables or views.TYPE r_emp is RECORD (sno smp.smpno%type,sname smp sname %type)%ROWTYPEsmpno,dept from smp;%ROWTYPE