O'Reilly logo

Oracle® PL/SQL® Interactive Workbook, Second Edition by Elena Silvestrova, Benjamin Rosenzweig

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 19 Records

Lab 19.1 ▪ Self-Review Answers

A1:
Questions Answers Comments
1) C %ROWTYPE means “based on a row.” This row may be based on a database table row or on a row returned by a cursor.
A2:
Questions Answers Comments
2) C When a field with a NOT NULL constraint is not initialized, a user-defined record causes an error.
A3:
Questions Answers Comments
3) B You are able to assign a table-based record to a cursor-based record and vice versa. This restriction applies to user-defined records that have the same structure yet different data types.
A4:
Questions Answers Comments
4) A An aggregate assignment statement between two user-defined records causes an error where the records are not based on the same type.
A5:
Questions Answers ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required