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


Please Help Members By Posting Answers For Below Questions

Where is sql database stored?

520


What is numeric function sql?

542


what are the join types in tsql? : Transact sql

576


What are secondary keys?

561


What is the difference between view and stored procedure?

494






How do I quit sql?

499


What are synonyms in sql?

534


How do I send sql query results to excel?

579


explain the difference between delete , truncate and drop commands? : Sql dba

548


What is synonyms?

573


How to check if a column is nullable before setting to nullable?

582


How do you take the union of two tables in sql?

515


What is sql keyword?

561


Which command is used to delete a trigger?

777


What is sharding in sql?

566