Understanding COMPOSITE DATATYPES:

Composite Datatypes are a group of datatypes which can contain multiple columns and multiple records. Records and Tables together are known as Composite Datatypes.

A PL/SQL record is a variable which holds a collection of separate fields. Every field is individually addressable. To give the reference to the field names can be done in both assignments and expressions. The fields within a record might have variant sizes and datatypes, like the columns of a database table. Records are a suitable way of storing a complete fetched row from a database table. By using %ROWTYPE attribute to declare a record based upon a set of database columns from a table or view and the fields within the record take their names and datatypes from the columns of the table or view.