Main diff between varray and nested tablea
Answer Posted / 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 |
Post New Answer View All Answers
Why use truncate instead of delete?
How is a process of pl/sql compiled?
What are the query optimization techniques?
What are the different set operators available in sql?
What are types of exception?
What is sharding in sql?
How to order siblings in oracle hierarchy queries?
How to know the last executed procedure?
Does user triggers have entry for trigger with compilation errors?
Define a temp table?
What is the least restrictive isolation level? : Transact sql
what are the 'mysql' command line arguments? : Sql dba
What are the benefits of pl sql?
What is use of term?
What is clustered and nonclustered index in sql?