Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Multiple databases query? NEED HELP
Try Cerebellum 1.2 product review at
http://www.visionsystems.com/products/index.shtml
There is a free demo available.
Hope that helps.
--
Josue Batista
ABC Tech Solutions
http://www.abcsolutions.org
[Java/Oracle/Linux] [C/S & Internet Database Apps]
Phillip H wrote in message <7m7p3l$noo$1_at_news1.mpx.com.au>...
>Hi All,
>
>I am doing a thesis that query against at least two databases. These
>databases are heterogeneous. It may include Oracle, Microsoft Access,
>Microsoft SQL and DB2. A single query will involve at least two tables
that
>can be in same or different databases.
>
>For example, Payroll data is stored in an Oracle DB, while staff task data
>is in an Access DB. Now I want to retrieve all staff's current salary and
>current task list by a single SELECT statement (syntax may vary):
>
> SELECT name, salary, task
> FROM current_salary cs, current_tasks ct
> WHERE cs.name = ct.name;
>
>The purpose is to hide the details of data distribution. I implement it
with
>Developer 2000. Any ideas on how to do it are appropriated. Are there any
>books or web sites helpful?
>
>Thanks in advanced.
>
>Phillip
>
>
Received on Sat Jul 10 1999 - 20:04:55 CDT
![]() |
![]() |