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@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 Tue Aug 14 2001 - 21:43:28 CDT