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

In PL/SQL, %TYPE is used to declare a variable with the data type of a previously declared variable or database column. In contrast, %ROWTYPE is used to declare a record representing an entire row in a table or view.