Multiple choice technology programming languages

The __________ attribute is used to declare variables based on definitions of columns in table

  1. %ROWTYPE

  2. %TYPE

  3. AS_COLUMN

  4. None of the above

Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

The %TYPE attribute in PL/SQL allows you to declare a variable that automatically inherits the datatype of a specific column in a database table. This provides maintainability - if the column's datatype changes, variables using %TYPE automatically adapt without code modification.