Home » Interview » Technology

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;

← Previous Question Next Question→

Discussion & Comments

No comments yet. Be the first to comment!
Join Discussion