Skip to Main Content
Oracle PL/SQL Programming: A Developer's Workbook
book

Oracle PL/SQL Programming: A Developer's Workbook

by Steven Feuerstein, Andrew Odewahn
May 2000
Intermediate to advanced content levelIntermediate to advanced
594 pages
11h 32m
English
O'Reilly Media, Inc.
Content preview from Oracle PL/SQL Programming: A Developer's Workbook

Intermediate

5-8.

A programmer-defined record is based on a record “type” you define within your code. Which of the following statements represent valid reasons for working with a programmer-defined record?

  1. You want a field in your record to be of type Boolean or some other datatype that is available in PL/SQL, but not in SQL.

  2. You want to write PL/SQL code that is independent of Oracle so it can be ported easily to other database vendor products such as SQL Server.

  3. The structure of the record you need, while consisting solely of SQL datatypes, does not match any table or cursor defined in your system.

  4. You don’t trust your table structures because the DBAs change them without notice, causing your programs to break.

  5. You want to avoid repetitive definitions of data structures by using nested records.

5-9.

Which of these statements about programmer-defined records are true, and which are false?

  1. The programmer-defined record gives the programmer tremendous flexibility and complete control over the number, names, and datatypes of fields in a record. It allows the creation of records that have nothing to do with either a table or cursor.

  2. You can declare fields to be NOT NULL, leaving it to the PL/SQL runtime engine to enforce your data integrity.

  3. A programmer-defined record can have as its field an index-by table, a programmer-defined subtype, another PL/SQL record type, or an object type.

  4. Working with programmer-defined records always involves two steps. First, define the record TYPE (which you must ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Oracle Database 12c PL/SQL Programming

Oracle Database 12c PL/SQL Programming

Michael McLaughlin
Oracle PL/SQL for DBAs

Oracle PL/SQL for DBAs

Arup Nanda, Steven Feuerstein
Oracle PL/SQL For Dummies

Oracle PL/SQL For Dummies

Michael Rosenblum, Paul Dorsey

Publisher Resources

ISBN: 9781449324070Supplemental ContentErrata Page