Connecting To SQL Server From Oracle Using Heterogeneous Services Generic Gateway
Posted on
6,502 Points
5:20
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
0 Comments
Suggested Videos
Using a combination of CROSS APPLY and VALUES one can efficiently "unpivot" data into normalised results that are far better for analysis.
After looking into a question at EE, a thought came to my mind that I considered would make a good article. "Transform Text copied from Excel Table into Real Table in SQL" as it is totally possible to do. Here's the result.
Suggested Courses
Next Video:SQL - Creating a Table