which of the following scenarios would you recommend using PL/SQL records?

In which of the following scenarios would you recommend using PL/SQL records?

In which of the following scenarios would you recommend using PL/SQL records?

A.
when you want to retrieve an entire row from a table and perform calculations

B.
when you know the number of elements in advance and the elements are usually accessed sequentially

C.
when you want to create a separate lookup table with multiple entries for each row of the main table, and access it through join queries

D.
when you want to create a relatively small lookup table, where the collection can be constructed in memory each time a subprogram is invoked



Leave a Reply 7

Your email address will not be published. Required fields are marked *


ankur

ankur

a:records
d: ?? (varrays ??)
c:nested tables
d: associative arrays

Hector Gonzalez

Hector Gonzalez

La respuesta correcta es la A).