I have to update value based on values from another table:
update OracleOb..NS.myTable set name = (select name from myTable1 where id = 1)
where id = 1
here the SQL has some problem. How can I get value from myTable1 and set it to myTable?
I am using MS SQL 2005.
Sorry I have to edit this question again. The table myTable is a linked object of Oracle table. I tried the suggested answer but I got error message:
The OLE DB provider "OraOLEDB.Oracle" for linked server "OracleOb" reported an error. The provider reported an unexpected catastrophic failure.