Using the %ROWTYPE attribute, you can define a record that contains fields corresponding to all columns fetched from a cursor or cursor variable. Each field takes on the data type of its corresponding column. The %ROWTYPE attribute is prefixed by a cursor name or cursor variable name.
record is an identifier assigned to the record. cursor is an explicitly declared cursor in the current scope.
This example shows how you can use a cursor with %ROWTYPE to get information about which employee works in which department: