Main diff between varray and nested tablea
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / dandu devendra
Varray: constrain table.Basically this table dense by default indexs start with 1.
Nested table: unconstrain table.
Is This Answer Correct ? | 3 Yes | 2 No |
Answer / prabu t
Varray -
Can be stored in the database.
Bounded (maximum length should be given).
Delete / Remove values only from the end.
Nested Tables -
Cannot be strored in the database.
Unbounded (No maximum length).
Delete / Remove values anywhere in the table.
Is This Answer Correct ? | 7 Yes | 8 No |
What does the argument [or replace] do?
if a table is getting updated what happens if a function is called from sql query?
what are all the different normalizations? : Sql dba
What is a sql trace file?
What is sql and its types?
Why sql query is slow?
how to use in conditions? : Sql dba
what is meant by urlencode and urldocode? : Sql dba
wht is the difference between sqlaserver2000 and 2005
Temporary table vs Table variable in sql server?
What is the difference between DELETE and TRUNCATE?
15 Answers Johns Hopkins University, Tech Mahindra,
What is sql deadlock?