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. ... Variables declared using %ROWTYPE are treated like those declared using a datatype name.

What is the main use of type Rowtype?

The %ROWTYPE attribute, used to declare PL/SQL variables of type record with fields that correspond to the columns of a table or view, is supported by the data server. Each field in a PL/SQL record assumes the data type of the corresponding column in the table.

What is %type and Rowtype?

%TYPE- The %TYPE lets you declare a constant, variable, collection element, etc as previously declared variable or column. ... %ROWTYPE- the %Rowtype attribute lets you declare a record that represents a row in the table. The fields of the row have same name and data types as column in the view.