Re: Declaring a global table in PL/SQL

From: Chris $ Val $ <chrisval_at_bigpond.com.au>
Date: Sat, 06 Aug 2005 06:22:52 GMT
Message-ID: <0HYIe.73158$oJ.49992@news-server.bigpond.net.au>

"William Robertson" <william.robertson_at_bigfoot.com> wrote in message news:1123161130.276025.79750_at_f14g2000cwb.googlegroups.com...
| Billy wrote:
| > absinth wrote:
| > > Why can't I have?
| > >
| > > CREATE OR REPLACE PACKAGE BODY test AS
| > > TYPE test_table IS TABLE OF VARCHAR2(30)
| > > INDEX BY VARCHAR2(2);
| > >
| > > DEMO_TABLE test_table;
| > > DEMO_TABLE('NO') := 'No';
| > >
| > > END test;
| > > /
| >
| > You can - as the responses show.
| >
| > But there is nothing "table" about PL/SQL "tables". The *CORRECT*
| > definition is dynamic arrays. And is what is used in every other
| > programming language out there.
| >
| > There's also a huge questionmark about why wanting to declare a global
| > dynamic array. 99% of the time is nothing but a brain fart that is
| > without substance and plain stinks. Where is the best place for data in
| > Oracle to reside? And the "in-a-global-dynamic-array" answer to that is
| > few and very far in-between.
| >
| > --
| > Billy

| "PL/SQL Tables" - isn't that what they used to call associative arrays
| in ancient times?

[snip]

They are still alternatively known as 'associative arrays' as well as 'index-by-tables'. Technically Oracle refers to these tables as collection types.

Cheers,
Chris Val Received on Sat Aug 06 2005 - 01:22:52 CDT