Main diff between varray and nested tablea

Answer Posted / srinivas

We should give the maximum size when we declare the varry, and if u perform delete then it removes the values from the end, use this varray when u know the size


we no need to give the size when we declare the nested tables,we can remove the values any where from the nested table,use this when u don't know the size.

Is This Answer Correct ?    4 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What does <> sql mean?

542


what is data control language? : Sql dba

588


What is lexical units in pl sql?

571


Explain the difference between rename and alias?

543


What is scope of pl sql developer in future?

595






What is the purpose of the sql select top clause?

557


How many times can we commit in a loop?

566


What is scalar and vector?

530


What is primary key sql?

544


Does sap use sql?

515


What are different types of tables in sql?

531


What is a database trigger?

612


what is the different between now() and current_date()? : Sql dba

526


How do you create a db file?

523


What is a trigger in sql?

638