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.

Questions by baskaranprasad

Showing Answers 1 - 1 of 1 Answers

Gupta

  • Aug 7th, 2006
 

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

  Was this answer useful?  Yes

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);

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions