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 |
How to select random rows from a table?
What does plvtab enables you to do when you showthe contents of pl/sql tables?
What is raw datatype in sql?
What is record type in pl sql?
package specification-3 procedures package body-4 procedures how can i write for other procedure in package body
can i use global variables in stored procedure or function
what is mean by forward declaration and where we'll use it.
display your age in months?
What is foreign key in sql with example?
What are the popular database management systems in the it industry?
what are the advantages and disadvantages of cascading style sheets? : Sql dba
What is the usage of nvl function?