Livio -- Thanks for the question regarding "Querying SQLServer tables from within an Oracle session", version 10.2.0

Submitted on 13-May-2008 11:35 Central time zone

Tom's latest followup | Bookmark | Bottom

Last updated 15-May-2008 21:40

You Asked

Dear Tom;

I need to query a SQLServer table from within an Oracle session, for example SQLPlus. Is there an easy way to do this, something like:

 select * from t@sql_server_link

May you redirect me to the appropriate documentation?

Thanks in advance.

Livio

and we said...

http://asktom.oracle.com/pls/asktom/f?p=100:1:4068880046972050::NO:RP::

Heterogeneous Connectivity

Reviews

broken link May 16, 2008 - 10am Central time zone

Bookmark | Bottom | Top

Reviewer: Jim from Phila, PA

the link appears to be broken.  all I get is Ask Tom Home

Exactly May 16, 2008 - 5pm Central time zone

Bookmark | Bottom | Top

Reviewer: DP

You should get the Ask Tom homepage with a search already done for Heterogeneous Connectivity and 
lots of resulting links about the sql server connectivity you seek.

HS rocks! May 17, 2008 - 5pm Central time zone

Bookmark | Bottom | Top

Reviewer: Duke Ganote from rolling hills of Anderson Township, Hamilton County, Ohio USA

If you've got Oracle on Windows, Heterogeneous Services is fabulous.  And that's not had to get, 
according The Takmeister:

http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:4406709207206#69674050442564

I use Heterogeneous Services a lot, connecting to Informix, SQL Server, DB2, etc.

The best tutorial is the Takmeister's example for Excel:

http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:4406709207206#18830681837358

"If you can use Heterogeneous Services on Excel, you can use it on anything!"

I recently used Heterogeneous Services to almost totally copy some DB2 schema objects: tables, 
views, and indexes

http://tinyurl.com/6mr926

Write a Review