PL/SQL Attributes: %TYPE And %ROWTYPE Explained

In PL/SQL, both %TYPE and %ROWTYPE are attributes that allow you to define variables that inherit the data type of a column or the structure of a table (or cursor). The key difference between them is the scope and purpose of their usage.


  
  
  1. %TYPE

The %TYPE attribute is used to declare a variable that inherits the data type of a specific column, field, or variable.

It is useful when you want to ensure that the variable you declare has the same data type as a particular column or another variable, making your code more maintainable and less prone to errors if the column's data type c...