Re: PL/SQL tables with multiple columns

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: 1997/06/26
Message-ID: <33b29434.11187987_at_newshost>#1/1

On Wed, 25 Jun 1997 18:00:31 -0400, Scott Cadle <scadle_at_ix.netcom.com> wrote:

>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?
>
Tables of records have been. Arbitrary keys, no. Here is an example. Starts with pl/sql inside a 7.3 database:

create or replace procedure demo_tbl
as

    type emp_array is table of emp%rowtype index by binary_integer;  

    theData emp_array;
    i number default 0;
begin

    for x in ( select * from emp ) loop

        theData(i) := x;
        i := i+1;

    end loop;  

    for n in 0 .. i-1 loop

        dbms_output.put_line( theData(n).ename || ' ' || theData(n).mgr );     end loop;
end;
/
>
>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?
>

They would be pl/sql versions 2.3.x

>Thanks,
>Scott Cadle
>

Thomas Kyte
tkyte_at_us.oracle.com
Oracle Government
Bethesda MD

http://govt.us.oracle.com/ -- downloadable utilities

---

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Thu Jun 26 1997 - 00:00:00 CEST