Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Can you select from a PL/SQL table (Collections in Oracle 8)
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