What is a Varray? What are the similarities and differences between a Varray and a PL/SQL Table?

What will be an ideal response?

A varray is another composite data type or collection type in PL/SQL. Varray stands for variable-size array. They are single-dimensional bounded collections of elements with the same data type. They retain their ordering and subscripts when stored in and retrieved from a database table. They are similar to PL/SQL table, and each element in a varray is assigned a subscript/index starting with 1.

Computer Science & Information Technology

You might also like to view...

Which process guarantees that you are the only one currently using the database?

A) Encryption B) Open exclusive C) Selfcert D) Password protect

Computer Science & Information Technology

What fraction of the membership of Congress is required to pass a Constitutional amendment?

What will be an ideal response?

Computer Science & Information Technology