Re: Can you select from a PL/SQL table (Collections in Oracle 8)

Paul Arscott wrote:

> Does anyone know if you select from a PL/SQL table (called Collections
> in Oracle 8)?
>
> ie
> DEFINE
> TYPE testtype IS TABLE OF testtable%ROWTYPE
> INDEX BY BINARY_INTEGER;
> mytest testtype;
>
> BEGIN
> ......populate mytest.
>
> select * from mytest;
>
> END;
>
> Paul
> p.s. Im using oracle 7.3.4

Please reply to paul.arscott_at_pwgsc.gc.ca Received on Mon Jun 12 2000 - 00:00:00 CDT