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 -> Can you select from a PL/SQL table (Collections in Oracle 8)

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: <3945347C.B4386F91@pwgsc.gc.ca>#1/1 






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
Received on Mon Jun 12 2000 - 00:00:00 CDT












Original text of this message













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