The %ROWTYPE attribute provides a record type that represents a row in a database table. The record can store an entire row of data selected from the table or fetched from a cursor or cursor variable.

Example:

%ROWTYPE pick the value as declare %type.

Explanation About Example :

So we see 2 line (emp_id employees.employee_id%type) their % means emp_id column as similar employee_id and employees is table name. Alternate way we can say that % Rowtype is work as copy past type.