Home » SQL & PL/SQL » SQL & PL/SQL » Fetch into array
Fetch into array [message #37177] Tue, 22 January 2002 11:42 Go to next message
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
Re: Fetch into array [message #37185 is a reply to message #37177] Wed, 23 January 2002 02:23 Go to previous messageGo to next message
pratap kumar tripathy
Messages: 660
Registered: January 2002
Senior Member
Hi,

use table of records.

cheers
pratap
Re: Fetch into array [message #37213 is a reply to message #37185] Thu, 24 January 2002 13:09 Go to previous message
Jamie Mack
Messages: 8
Registered: January 2002
Junior Member
Thanks alot. Worked fine
Cheers Jamie
Previous Topic: time issue
Next Topic: Arrays and functions
Goto Forum:
  


Current Time: Mon Jun 01 21:45:50 CDT 2020