abjiang wrote:

> I have two sets of queries that query two different databases. I need to
> batch them together and execute them at same time. What is the best ay
> of doing this? Thanks in advance for any advice.
>
> Abby
>
> --
> Posted via http://dbforums.com

Assuming you mean databases in the Oracle sense ... a database link and
UNION ALL.

If what you mean is two different schemas in a single database ... just
UNION ALL.

--
Daniel Morgan
http://www.outreach.washington.edu/e...ad/oad_crs.asp
damorgan@x.washington.edu
(replace 'x' with a 'u' to reply)