0 votes
in Oracle by

What is VArray?

1 Answer

0 votes
by

A VARRAY is a type of collection in which each element is referenced by a positive integer called the array index. The maximum cardinality of the VARRAY is specified in the type definition.

The TYPE IS VARRAY statement is used to define a VARRAY collection type.

Syntax

Read syntax diagramSkip visual syntax diagramTYPEvarraytypeIS VARRAY(n)OFdatatype;

Description

varraytype

An identifier that is assigned to the array type.

n

The maximum number of elements in the array type.

datatype

A supported data type, such as NUMBER, VARCHAR2, RECORD, VARRAY, or associative array type. The %TYPE attribute and the %ROWTYPE attribute are also supported.

Related questions

+1 vote
asked Jul 29, 2020 in Oracle by Hodge
0 votes
0 votes
asked Jul 29, 2020 in Oracle by Hodge
...