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
INSERT Command in SQL Loosely speaking, INSERT takes the rows of a given source table and adds them to the specified target table, retaining all the existing rows in the targ

PPD , CPA, Filesharing Site Project Description: This is very easy I need a PPD , CPA, Filesharing Site. [PPD] stands for (pay per download) example hotsharecash [Files

Naming Conventions The similar naming conventions apply to all PL/SQL program items and units including the variables, cursors, constants, cursor variables, procedures, exception

BEGIN Parameter Description in pl sql: BEGIN: This keyword signals the beginning of the executable section of a PL/SQL block, that contains executable statements. The execut

I want to implement heap sort algorithm in pl sql please share the source code for guidance

COMMIT Statement The COMMIT statement explicitly makes everlasting changes to the database during the present transaction. The Changes made to the database are not considered e

1. Create a procedure called TAX_COST_SP to accomplish the tax calculation task. Keep in mind that the state and subtotal values are inputs into the procedure and the procedure is

The requirements as follows: Create a folder called "SECURITY" on the server and upload all your project files to that folder. Please note, the "SECURITY" folder is NOT to be IN

Project Description: I want to rebuild it and add better content to it It will include up to 5 forms The data will be saved on SQL server and the data access layer could b

Advantages of Subprograms The Subprograms give extensibility; that is, tailor the PL/SQL language to suit your requirements. For illustration, if you require a procedure which