What are the different types of collections supported in Oracle?PL/SQL datatypes TABLE and VARRAY, allow us to declare the collections nested tables, associative arrays, and variable-size arrays.

baskaranprasad
Profile Answers by baskaranprasad Questions by baskaranprasad
May 29th, 2006
2
3912

Showing Answers 1 - 2 of 2 Answers

Gupta

Aug 7th, 2006

Types are Index -by- table, Nested Tables and Varray!

BASAVARAJ KOLUR

Mar 8th, 2007

plsql supports mainly 3 types of collections
    1> index by binary_integer
    2> nested table
    3>varrays
index by binary_integer and nested table are collectivily known as plsql tables
and nested table and varray can be stored in database table but index by binary_integer cant be stored in database table

the syntax for index by binary_integer
ex: declare
         type basu is table of varchar2(10)
              index by binary_integer;
if you leave the key word binary_integer it becomes nested table
ex: declare
               type basu is table of varchar2(10);
the syntax for varrays is
    ex: declare
            type basu is varray(5) of varchar2(10);