Home » SQL & PL/SQL » SQL & PL/SQL » Join tables from two databases
Join tables from two databases [message #251417] Fri, 13 July 2007 09:17 Go to next message
kalkumar
Messages: 8
Registered: July 2007
Junior Member
Hi,
In my application I have to join two tables, One is from Oracle database and oe table is from SQLSERVER database.
How to perform this operation.
Thanks in advance.
Re: Join tables from two databases [message #251421 is a reply to message #251417] Fri, 13 July 2007 09:22 Go to previous messageGo to next message
BlackSwan
Messages: 25045
Registered: January 2009
Location: SoCal
Senior Member
By using PERL
Re: Join tables from two databases [message #251424 is a reply to message #251417] Fri, 13 July 2007 09:31 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
With ODBC.

Regards
Michel
Re: Join tables from two databases [message #251719 is a reply to message #251424] Mon, 16 July 2007 03:32 Go to previous messageGo to next message
Maaher
Messages: 7062
Registered: December 2001
Senior Member
Michel Cadot wrote on Fri, 13 July 2007 16:31
With ODBC.
I'd go for ODBC too, then you can use Heterogeneous Services.

MHE
Re: Join tables from two databases [message #251750 is a reply to message #251417] Mon, 16 July 2007 09:20 Go to previous message
Bill B
Messages: 1484
Registered: December 2004
Senior Member
1) setup a database link to your sql-server.
2) use it in a select


select a.col2,b.col2
from my_table a, their_table@sqlsvr
where a.id = b.id;

Previous Topic: Store file in database tables
Next Topic: Need a query
Goto Forum:
  


Current Time: Wed Dec 07 16:19:34 CST 2016

Total time taken to generate the page: 0.08494 seconds