Difference between Varray and Nested Table

What is the difference between Varray And Nested Table?

Questions by Kanhucharan   answers by Kanhucharan

Showing Answers 1 - 3 of 3 Answers

Khurram Ali Khan

  • May 2nd, 2008
 

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.

  Was this answer useful?  Yes

Sheraz Baig

  • Dec 3rd, 2013
 

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

  Was this answer useful?  Yes

Vishnu Bharath

  • Jan 8th, 2014
 

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.

  Was this answer useful?  Yes

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