Oracle collections

What are the types of collection in PL/SQL? What is the advantage of nested tables?

Questions by sidd_130

Showing Answers 1 - 1 of 1 Answers


  • Nov 6th, 2012

Varrays,nested tables,index by tables are oracle collection.Index by tables also known as associative array similar to hashtables in java. Varrays are like arrays in java static in nature need to define maximum size at time of declaration.Nested tables are like nested class in java holding a table as a column of a table.

  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