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
set serveroutput on declare a number(5); b number(5); c number(5); begin a:=&a; b:=&b; c:=a/b; dbms_output.put_line(c); exception when zero_d

Challenge 1 You are required to do the project and write a test plan for it. Demo 4 is a check writer program for employees. In it, the user enters all information about the

Parameter and Keyword Description: type_name: This identifies a user-defined type specifier that is used in the subsequent declarations of the objects. AUTHID Clause:

Using SAVEPOINT The SAVEPOINT names and marks the present point in the processing of a transaction. Used with the ROLLBACK TO statement, the savepoints undo parts of a transac

When Are Constraints Checked Under the model constraints are conceptually checked at all statement boundaries (and only at statement boundaries). By default the same is true

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

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

Literature review

Advantages of Exceptions Using the exceptions for the error handling has many benefits. Without an exception handling, every time you issue a command, you should ensure for th

DELETE Command - SQL Loosely speaking, DELETE removes some existing rows from its target table. Suppose the university decides that course C3 is to be withdrawn. Example shows