Monday, April 6, 2009

How i can update data in the tables present in Oracle using Sql stored procedure?

In ms sql server, you can create linked servers that point to Oracle databases. check out the sp_addlinkedserver stored procedure, and the OPENQUERY() function in the books online.
You can also insert, update and delete using the openquery function...

No comments: