Total Pageviews

April 12, 2019

4/12/2019 03:53:00 PM


You need a small lookup table that will be generated in memory every time a PL/SQL procedure is invoked or a package that declares it is initialized. Which of the following is the proper composite data type to use?


Associative array(An associative array (formerly called PL/SQL table or index-by table) is a set of key-value pairs. Each key is a unique index, used to locate the associated value with the syntax variable_name(index))For more information on index by table

2)Which of the following is a valid reason for deciding to create a subprogram as a function rather than as a procedure?

It must be callable from SQL statements


Related Posts Plugin for WordPress, Blogger...