Oracle – Data Type – Difference between Column Type and Row Type

Column Type

Column Type (i.e.  %TYPE) is used to declare a field with the same type as that of a specified table’s column:

Example:

Difference between and Column Type and Row Type

Row Type

Row type (i.e. %ROWTYPE) is used to declare a record with the same types as found in the specified database table, view or cursor:

Example:

Difference between and Column Type and Row Type