Difference between %TYPE and %ROWTYPE.

Correct Answer: %type is used to declare a field of a table while %rowtype is used to declare a record with the same type as specified in that table, view or cursor Example of %type: DECLARE v_EmployeeName empename%TYPE Example of %rowtype DECLARE v_empployee emp%ROWTYPE;