Array in PL/SQL

From: <mouyang_at_yahoo.com>
Date: 1998/03/14
Message-ID: <6efikv$187$1@nnrp1.dejanews.com>#1/1

Hi all,

I want to use arrays in PL/SQL. Is there any way to implement a pseudo array or implement variables act as array?

And another question is: in a distributed query such as :   select * from tableA_at_siteA
  union
  select * from tableB_at_siteB
Oracle will execute the two subqueries parallelly or not?

Thanks for any help.

Ouyang

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Sat Mar 14 1998 - 00:00:00 CST