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

What is a subquery in sql?

597


Is postgresql a nosql database?

649


How do I create an index in word?

626


What is indexing in sql and its types?

631


Is the primary key an index?

695






What is a column in a table?

661


what is the difference between truncate and delete statement? : Transact sql

651


What are sql commands?

591


Does group by remove duplicates?

658


Can we insert in view in sql?

673


How can we connect an Android App to an Oracle database and use the PL/SQL procedural code?

679


What is the reports view in oracle sql developer?

648


what is the command line end user interface - mysql? : Sql dba

597


What are the different sql commands?

623


What are predefined functions in sql?

615