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 dml statement?
Why are aggregate functions called so?
What is %type in sql?
What is the difference between drop and truncate commands?
Is sql better than excel?
What is localdb mssqllocaldb?
How do I edit a trigger in sql developer?
What is the need of merge statement?
Which column of the user triggers data dictionary view displays the database event that will fire the trigger?
How many types of privileges are available in sql?
Which query operators in sql is used for pattern matching?
What is the difference between the conventional and direct path loads? : aql loader
What are the most important characteristics of pl/sql?
How to avoid duplicate records in a query?
what is table? : Sql dba