PL/SQL %TYPE and %ROWTYPE – Usage, Differences, and Examples Explained

• %TYPE is used to declare a variable that is of the same type as a specified table’s column.

     
        example: Emp_number emp.empno%type;

• %ROWTYPE is used to declare a record (the variable that represents the entire row of a table).

         example: Emp_record emp%rowtype;