Multiple choice technology databases

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 declares a variable with the same data type as a specified column in a table. %ROWTYPE declares a record type matching an entire row. AS_COLUMN doesn't exist in PL/SQL. %TYPE is useful for maintaining type compatibility without hardcoding specific types.