OraFAQ Forum: SQL & PL/SQL » Fetch into array

Home » SQL & PL/SQL » SQL & PL/SQL » Fetch into array

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Fetch into array [message #37177]

Tue, 22 January 2002 11:42

Jamie Mack
Messages: 8
Registered: January 2002

Junior Member

Hey there, I want to do a cusor fetch into an array based on two tables. With only certain fields is this possible?
e.g

select a,
b,
c,
d
from x,
y
where x.a = y.b;

In vb you can have a 3d array so this is how it should look is.

array(1, 1) will be equal to record1.a
array(1, 2) will be equal to record1.b e.t.c

array(2, 1) will be equal to record2.a
array(2, 2) will be equal to record2.b e.t.c

Is this possible???

Cheers Jamie

Report message to a moderator