Re: How to execute queries that query different db at same time?

From: Daniel Morgan <damorgan_at_exxesolutions.com>
Date: Thu, 14 Aug 2003 15:53:18 -0700
Message-ID: <3F3C12DE.1835AF7F@exxesolutions.com>

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/extinfo/certprog/oad/oad_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)

Received on Thu Aug 14 2003 - 17:53:18 CDT