Multiple choice technology databases

What is the use of %ROWTYPE in PL/SQL?

  1. %ROWTYPE allows you to associate a variable with an entire table row

  2. %ROWTYPE associates a variable with a single column type

  3. Both of the above

  4. None of the above
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

In PL/SQL, %ROWTYPE provides a record type that represents a row in a database table. The record fields have the same names and data types as the columns of the table, allowing you to associate a variable with an entire row.

Keep practicing — related questions