The %TYPE attribute tells the system to look up the data type of a database column and use this data type for the declared variable.
The data server supports the % TYPE attribute, which is used in PL/SQL variable and parameter declarations. The maintenance of type compatibility between table columns and PL/SQL variables is ensured by the use of this property.
The prefix to the % TYPE attribute must be a qualified column name in dot notation or the name of a previously declared variable. The variable being declared has the data type associated with this column or variable. The declaration code does not need to be changed if the column's or variable's data type changes. The formal parameter declarations can also be used in conjunction with the % TYPE property.
To learn more about variable, refer
https://brainly.com/question/14006589
#SPJ4
