Re: Joining tables - SQL Sever & Oracle

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Tue, 15 Jan 2002 00:13:27 +0100
Message-ID: <rfp64u0a073p5hn24b8bed44gvvjt2uvvu@4ax.com>

On 14 Jan 2002 14:40:21 -0800, misplacedmackem_at_hotmail.com (Misplaced Mackem) wrote:

>I have two SQL Server databases and I am migrating one of them into
>Oracle. The DB that is being migrated has a stored procedure that
>performs joins between the SQL Server DB and what is now the Oracle DB
>and places the results into a new table.
>
>Is there any way I can do this (Perform a Join with a remote SQL
>Server database table) from within Oracle? If not, any suggestions?
>
>Thanks
>Drew

Oracle has a gateway product for this type of access.

Hth

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Mon Jan 14 2002 - 17:13:27 CST