Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Updating And Inserting data in a Oracle table from Microsft SQLServer

Status
Not open for further replies.

Packermann

Programmer
May 17, 2000
15
US
I am able to do a query, but nothing else.<br><br>Here is my statement that works:<br><br>SELECT *<br>FROM OPENQUERY(CHINIKU01, 'SELECT CODE FROM LARRY.nitc_lookup_values') <br><br>This works fine. But how can I update the remote table, or insert into another table that resides on the Oracle database? The Micsosoft documentation in linkedservers says I can do that, but gives no examples.<br><br><br>
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top