Re: PL/SQL tables with multiple columns

From: Scott Urman <surman_at_dlsun338.us.oracle.com>
Date: 1997/06/26
Message-ID: <5oumv6$ouo$1_at_inet16.us.oracle.com>#1/1

In article <33B194FF.B44FEB12_at_ix.netcom.com>, Scott Cadle <scadle_at_ix.netcom.com> writes:
|> I have a couple of questions....
|>
|>
|> The PL/SQL 2.0 User Guide and Reference states:
|> "Future versions of PL/SQL will allow PL/SQL tables to have multiple,
|> named columns and composite primary keys of any type."
|>
|> 1) Has this functionality been delivered yet? If so, in what versions of
|> PL/SQL?
Version 2.3 of PL/SQL, available with Oracle 7.3, allows PL/SQL tables of records. This is the first part of the statement, allowing "multiple, named columns". The second part deals with the INDEX BY clause. In Oracle7, you hav to INDEX BY BINARY INTEGER. In PL/SQL version 8, available as of two days ago :) with Oracle8, you can create nested tables, which don't have the INDEX BY clause. The primary key is still an integer value, though. The advantage of nested tables is that they can be stored in a database table, and you can access them with SQL as well as with PL/SQL by element.

|>
|>
|> 2) I will be using Oracle 7.3 and do not know what version of PL/SQL
|> comes with 7.3. Does anyone know what versions of PL/SQL are supported
|> under Oracle 7.3?

Here's the chart of PL/SQL vs. Oracle version numbers:

Oracle version PL/SQL version
-------------- --------------

< 6            N/A
6.0            1.0
7.0            2.0
7.1            2.1
7.2            2.2
7.3            2.3
8.0            8.0

Subsequent digits also match, ie Oracle 7.3.2 has PL/SQL 2.3.2.

|>
|> Thanks,
|> Scott Cadle
|>

PS: I talk about these new features of PL/SQL 8, including nested tables, other collection types, and object types in the upcoming _Oracle8 PL/SQL Programming_. It will be published by Oracle Press and should be available in August. :)

---

Scott Urman Oracle Corporation surman_at_us.oracle.com

---

Author of _Oracle PL/SQL Programming_ ISBN 0-07-882176-2 Published by Oracle Press - http://www.osborne.com/oracle/index.htm

---

"The opinions expressed here are my own, and are not necessarily that of  Oracle Corporation"

---

Received on Thu Jun 26 1997 - 00:00:00 CEST