Re: PL/SQL tables datatype

ttran_at_ssofa.com wrote:
>
> Could any one explain to us in PL/SQL table datatype, is there any
> limitation for example size, memory usage, etc... ? Also when using
> table datatype in PL/SQL which memory does the PL/SQL uses? is it SGA,
> private area, or OS ?
>
> -------------------==== Posted via Deja News ====-----------------------
> http://www.dejanews.com/ Search, Read, Post to Usenet

You will find several topics on PL/SQL Table datatypes in "RevealNet PL/SQL Knowledge Base". You can download a copy and try it out at http://www.revealnet.com

Here is a portion of one of the topics:

• PL/SQL Tables can store scalar types, such as a table of dates. They can also store composite structures. Examples are tables of EMP%ROWTYPE and a table of records.
• PL/SQL tables are one-dimensional. For example, you cannot declare a table so that it is referenced as: my_table(10, 44);
• Components of a PL/SQL table must be of the same type.
• For a PL/SQL table, memory is allocated as elements and are assigned to the table components (array locations).
• Elements of PL/SQL Tables can be referenced in any order. You can assign a value to any row in the table, provided the table index falls within the valid range of BINARY_INTEGER.
• PL/SQL Tables are indexed by BINARY_INTEGER literal values for any expression that evaluates to a BINARY_INTEGER number.

Best wishes,

Cam White
RevealNet, Inc.
(800) 738-3254 Received on Mon Mar 31 1997 - 00:00:00 CEST