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 is the difference between a primary key and a unique key?
What is output spooling in sql*plus?
How to take user input in pl sql?
Does varchar need length?
what is oltp (online transaction processing)? : Sql dba
What is left join in postgresql?
Which are sql * plus commands?
how to analyze tables with 'mysqlcheck'? : Sql dba
What is the default isolation level in sql server? : Transact sql
What is normalization in a database?
What is range partitioning?
What are the indexing methods?
What is a sql driver?
What is scope and visibility in PL/SQL?
Is it possible for a table to have more than one foreign key?