WELCOME, GUEST

Minimize
Oct 2008 - Collections in PL/SQL

Which of the following fragments does not contain a valid declaration of a collection type (assuming a table named employees is defined)?

A.

DECLARE
   TYPE employees_array_t IS TABLE OF employees%ROWTYPE
      INDEX BY INTEGER;

B.

DECLARE
   TYPE employees_array_t IS TABLE OF employees%ROWTYPE;

C.

DECLARE
   TYPE employees_array_t IS VARRAY(3) OF employees%ROWTYPE;

D.

DECLARE
   TYPE employees_array_t IS TABLE OF employees%ROWTYPE
      INDEX BY PLS_INTEGER;



Submit