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
What is the use of index in sql?
explain the options of myisamchk to improve the performance of a table. : Sql dba
what is clause? : Sql dba
What is schema in sql?
what is row? : Sql dba
How many parts of a pl sql block are optional?
What is sqlite used for?
What are the rules to be applied to nulls whilst doing comparisons?
How can I delete duplicate rows?
How do you copy a table in sql?
Can we create clustered index without primary key?
What is mdf ldf and ndf?
what is user defined functions? : Sql dba
What is benefit of creating memory optimized table?
How do you add a column to a table?