Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: Can you select from a PL/SQL table (Collections in Oracle 8)

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

From: Paul Arscott <Paul.Arscott_at_pwgsc.gc.ca>
Date: 2000/06/12
Message-ID: <39453BA1.E9368A8D@pwgsc.gc.ca>#1/1

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US