Saturday, March 30, 2013

Comparison of PL/SQL COLLECTIONS - I

NAME VARRAY NESTED TABLE ASSOCIATIVE ARRAY
SIZE Bounded Unbounded Unbounded
DENSE/SPARSE DENSE Both Both
INDEX/SUBSCRIPT DATATYPE Integer Integer Integer/String
WHERE CREATED pl/sql block or at schema level pl/sql block or at schema level Only in a pl/sql block
CAN BE OBJECT TYPE ATTRIBUTE Yes No No

No comments:

Post a Comment