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 mean by Rowtype and type record?

Answered On : Apr 18th, 2008. %rowtype is an attribute to inherit datatypes of attributes of a table into a RECORD variable. Type record is a keyword to create record type using either explicitly specifying atrributes or by implecitly inheriting attributes from a table or a existing cursor.