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

Which one is better sql or oracle?

701


What is pls integer?

779


What is a dirty read sql?

714


Explain the difference between drop and truncate commands in sql?

738


What is materialized view in sql?

651






What is mutating error in pl sql?

750


What are the possible values for the boolean data field?

689


What are sql commands?

696


what is column? : Sql dba

744


State few characteristics of pl/sql?

723


What is the difference between Union and Union all. Which is faster.

1063


What is pl/sql table? Why is it used?

734


how many ways we can we find the current date using mysql? : Sql dba

810


What is the starting oracle error number?

754


Why commit is not used in triggers?

773