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
I need to write one function and one procedure to query a Oracle 10.1 DB using PL SQL. I have the schema and exact queries...along with work Ive started and a template to put the a

Create the four tables and populate them with the given data. Answer the following queries in SQL. 1. Get all part-color/part-city combinations. Note: Here and subsequently, the

Hi,am developing a library system and relating all the table is somehow complex,could you kindly assist me

Parameter SELF in pl/sql The MEMBER methods recognize a built-in parameter named SELF that is an instance of the object type. Whether declared explicitly or implicitly, it is

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 man

Inner Join We have learned how to retrieve data from one table by using SELECT statement. But, as we have learned, normalized relational databases mean the data is spread betw

Overloading: Similar to packaged subprograms, methods of the same type can be overloaded. That is, you can use similar name for various methods if their formal parameters diff

Project Description: I want a small relational database to be built. I want the database to have the subsequent information tables: Employee Information Document storage

Opening a Cursor Opening the cursor executes the query & identifies the result set that consists of all rows that meet the query search criteria. For the cursors declared usin

Parameter and Keyword Description: package_name: This construct identifies the package. AUTHID Clause: This determine whether all the packaged subprograms impleme