Oracle PL/SQL Record Types and Anchored Types.

preview_player
Показать описание
This video is about PL/SQL Record Types and Anchored Types. A data type of a variable can be set by anchoring the type to that of previously defined element like a column or row . This is achieved by providing %TYPE or %ROWTYPE. So if the data type of that particular column or any column in that row of the table changes at any stage you don't need to change the data type in PL/SQL code since it is not hard coded.
A variable of record data type can be declared to hold the data from all of the columns in a row.
Рекомендации по теме