RE: Differentiate between %type and %rowtype attribute...
type and rowtype provides data independence reduces maintainance cost and allows programs to adapt as the database changes due to new business requirements. rowtype is used to declare a record with the same types as found in the specified database table view or a cursor. type is used to declare a field with the same type as found in the specified table's column.
RE: Differentiate between %type and %rowtype attribute...
type will use for to define at column level.
rowtype is used to define for one or more than one columns ( like row or record or tuple ) means its user define type which hold one or more than one columns along with it. and generally it used with Cursor.
