OracleConnections

Oracle Community Network

Difference between varray and nested table

What is the difference between varray and nested table in Oracle?

4 members like this

▶ Reply to This

Replies to This Discussion

Permalink Reply by Nelda Kalina on January 30, 2014 at 7:09pm

They are Oracle data types
those who knoww any language like C and java then it is easy to understand the concept of Varray, as it is related to ARRAY structure of C or java language.

where as Nested Table concept is related to Struct data type of C or java langauge.

▶ Reply

Permalink Reply by Creola Mastro on January 30, 2014 at 7:09pm

Both are type of collections in Oracle. In Varray because its not stored in database columns so no DML operation can be implemented but on other hand as Nested tables we can perform DML operations

▶ Reply

Permalink Reply by Georgina Valtierra on January 30, 2014 at 7:11pm

Varrays are generally dense , that mean you cannot delete elements of the varray.But the elements of the Nested Table are generally sparse in nature and hence the elements can be deleted in between using the delete function. Varrays have fixed length (length declared during the declaration time), while Nested table can have unlimited length.