Re: Access to different Oracle (8i) Databases in one SQL

[Quoted] "AnotherUser" <AnotherUser_at_abc.com.au> wrote in news:b43hai$d83$1_at_mws-stat- syd.cdn.telstra.com.au:

> Hi Everyone,
>
> I have on my Server different Databases A, B, C, D etc ...which require a
> different Loggons and passwords.
>
> How can I access all these in one SQL ??

Easily.

What is "in one SQL"?

SELECT A.COL1, B.COL2, C.COL3, D.COL4

FROM TABLE_A_at_A A,
     TABLE_B_at_B B,
     TABLE_C_at_C C,
     TABLE_D_at_D D;