What is Varrays?

What is Varrays?

VARRAY is varying array type that is typically used when the number of instances to be stored is small. It has a set of data elements and all are of the same data type. The size of VARRAY determines the number of elements.

Example:
Defining a VARRAY object
CREATE OR REPLACE TYPE ProjectList AS VARRAY(50) OF Project;

Varrays are one-dimensional, arrays. The maximum length is defined in the declaration itself. These can be only used when you know in advance about the maximum number of items to be stored.

For example: One person can have multiple phone numbers. If we are storing this data in the tables, then we can store multiple phone numbers corresponding to single Name. If we know the maximum number of phone numbers, then we can use Varrays, else we use nested tables.

Oracle - What is Varrays? - April 10, 2009 at 11:00 AM

What is Varrays?  

Varrays, variable length array is quite similar to array of C++ or Java. It has fixed upper-bound size that has to be specified while it is declared. 

Oracle - What is Varrays? - June 18, 2009 at 13:00 PM

Variable length array, Varray is a datatype that is quite similar to an array in C or java. The storage pattern of Varray is same as a C array. Elements are inserted into a varray starting at index 1. 

Also read

What is a cursor variable?

A cursor variable is capable to get associated with different SELECT statements at run time. It is a reference type which is quite similar to pointer in C. In order to use cursor variable...........

What is a cursor? What are its types?

Oracle engine uses private working area to process queries. This work area is called as cursor. The data that is stored in the cursor is called as Active Data Set.............

What is a JOIN? Explain types of JOIN in oracle.

A join is a query that extracts data from two or more tables, views or snapshots.........

Explain the difference between trigger and stored procedure.

Procedure runs only when one call them manually whereas a trigger runs when there is any activity (insert,update,delete) on table on which the trigger is written...........

<<Previous  Next>>

Write your comment - Share Knowledge and Experience