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_at_pwgsc.gc.ca>#1/1
Date: 2000/06/12
Message-ID: <3945347C.B4386F91_at_pwgsc.gc.ca>#1/1
[Quoted] [Quoted] Does anyone know if you select from a PL/SQL table (called Collections in Oracle 8)?
ie
DEFINE
[Quoted] 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 CEST