You create database links, which allow you to select from different
database at the same time:
see CREATE DATABASE LINK ....
Example: select * from mytable_at_DIFFERENT_DATABASE
where DIFFERENT_DATABASE is a database link.
--
Terry Dykstra [TeamPS]
Canadian Forest Oil Ltd.
Robert Yang <NOSPAM_ryang_at_teleport.com_NOSPAM> wrote in article
<Q8N_.550$UC3.446068_at_news2.teleport.com>...
> Hi,
>
> We are porting from MS SQL Server 6.5 to Oracle 7.3 and are quite
confused,
> as you might expect, so please bear with me 8)
>
> There is a concept in SQL Server of multiple databases on a given server
> which can
> contain the same schema (tables, stored procedures, etc.). When
connecting
> with
> DB-Lib, the dbuse() API can be used to set the desired default database,
so
> that
> SQL commands like "Select Name from My_Table" can be executed.
>
> However, I cannot see how to do this with OCI or even Embedded SQL. It
> would seem
> that the database name must be specified for non-default databases, e.g.
> "Select Name from MyDatabase.MyTable".
>
> Any insight would be appreciated !
> --
> Rob Yang
> Sr. Software Engineer
> San Jose, CA, USA
>
>
>
>
>
>
Received on Wed Apr 22 1998 - 14:13:15 CDT
