Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Access to different Oracle (8i) Databases in one SQL
"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;Received on Tue Mar 04 2003 - 19:17:46 CST