Re: Use of more than 1 database, is it possible?
From: Steve Long <slong3_at_mediaone.net>
Date: Wed, 15 Aug 2001 02:43:28 GMT
Message-ID: <klle7.1458$L8.20349_at_typhoon.jacksonville.mediaone.net>
Date: Wed, 15 Aug 2001 02:43:28 GMT
Message-ID: <klle7.1458$L8.20349_at_typhoon.jacksonville.mediaone.net>
yes, but it may be product specific. in oracle, one may create a database link which in effect is a synonym for a table in another database. for syntax and details, refer to the oracle SQL manual under "create database link" and "create synonym" (in that order).
"Panda" <pandabearz_at_hotmail.com> wrote in message
news:a83f5b83.0108141356.6ca32946_at_posting.google.com...
> Hi, I just wanted to know if there is any way to use tables from more
> than 1 database. Rather than write SQL statements using tables from 1
> database, is there a way to write SQL statements using tables from
> more than 1 database. Please explain me and thank you for your help.
Received on Wed Aug 15 2001 - 04:43:28 CEST