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
What do you know by pl/sql cursors?
What is date functions?
when is the use of update_statistics command? : Sql dba
How do I run a script in sql developer?
what does it mean to have quoted_identifier on? What are the implications of having it off? : Sql dba
What are all different types of collation sensitivity?
Is primary key is clustered index?
how to analyze tables with 'mysqlcheck'? : Sql dba
Is sqlite good enough for production?
Which is faster union or join?
how to concatenate two character strings? : Sql dba
Cite the differences between execution of triggers and stored procedures?
What are the differences between implicit and explicit cursors?
What is left join in postgresql?
What are sql built in functions?