Understanding varrays, PL-SQL Programming

Understanding Varrays

The Items of type VARRAY are termed as the varrays. They permit you to relate a single identifier with the whole collection. This relationship lets you manipulate the collection as an entire and reference individual elements easily.

 

1082_Understanding Varrays.jpg

                                                   Figure: Varray of Size 10


The varray has a highest size that you must specify in its type definition. Its index has a fixed lower bound of 1 and an extensible upper bound. For e.g. the current upper bound for varray Grades is 7, but you can expand it to 8, 9, or 10. And hence, a varray can contain a varying number of elements, from zero (when empty) to the highest specified in its type definition.

Posted Date: 10/3/2012 6:31:02 AM | Location : United States







Related Discussions:- Understanding varrays, Assignment Help, Ask Question on Understanding varrays, Get Answer, Expert's Help, Understanding varrays Discussions

Write discussion on Understanding varrays
Your posts are moderated
Related Questions
OUT Mode An OUT parameter returns values to the caller of a subprogram. Within the subprogram, an OUT parameter act like a variable. That means that you can use an OUT formal

Controlling Cursor Variables You use 3 statements to control the cursor variable: OPEN-FOR, FETCH, & CLOSE. At First, you OPEN a cursor variable FOR a multi-row query. Then, y

ROWID and UROWID Internally, every database table has a ROWID pseudo column that stores binary values known as rowids. Each rowid shows the storage address of a row. A physical

MAX and MIN operator in SQL Example: (SELECT MAX (Mark) FROM EXAM_MARK WHERE StudentId = 'S1') (SELECT MIN (Mark) FROM EXAM_MARK WHERE StudentId = 'S1') Example

Overview of control structures According to the structure theorem, any computer program can be written by using the basic control structures as shown in figure below. They can b

MECHANISTI S THEORY-HAECKEL (1866) - Haeckel stating that after each catalysm, some new organism suddenly forms as a chance event in one stride from inanimate matter and sub

Keys in SQL SQL support for keys in the following respects: SQL does not require at least one key for every base table. If no key is explicitly declared, then KEY {ALL B

%FOUND Subsequent to a cursor or cursor variable is opened but before the first fetch, the %FOUND yields NULL. Afterward, it yields TRUE when the last fetch returned a row, or

Conditionals - SQL At first sight SQL does not appear to have a single operator for expressing logical implication. In this respect it would be in common with most programming

write the program for traffic control system with 10 second, 15 secod, and 20 second delay