jaswanthi.p

 Profile Answers by jaswanthi.p 

• Mar 8th, 2007

 

array is set of values of same datatype.. where as tables can store values of diff datatypes.. also tables has no upper limit where as arrays has.

krishnaindia2007

 Profile Answers by krishnaindia2007 

• May 8th, 2008

 

PL/SQL tables are temporary array like objects used in a PL/SQL Block. The size of pl/sql table is unconstrained. For varrays we need to specify upperbound.

Pl/sql tables can not be stored in database where as varrays can be stored in database.

We can use negetive index for pl/sql tables. In varrays negetive index is not allowed.

In pl/sql tables data need not be stored in consecutive rows. Varrays are dense and retain their order while storing in database.

You can not perform DML operations on PL/SQL table . DML operations can be performed on Varrays.