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
Which one is better sql or oracle?
What is pls integer?
What is a dirty read sql?
Explain the difference between drop and truncate commands in sql?
What is materialized view in sql?
What is mutating error in pl sql?
What are the possible values for the boolean data field?
What are sql commands?
what is column? : Sql dba
State few characteristics of pl/sql?
What is the difference between Union and Union all. Which is faster.
What is pl/sql table? Why is it used?
how many ways we can we find the current date using mysql? : Sql dba
What is the starting oracle error number?
Why commit is not used in triggers?