How to update Oracle DB from SQL server through link server?

[hmanhha]

Hi All. I Have a SQL Server.This server have link server to Oracle DB. I can select anything from oracle DB through this SQL server such as. Select * from [ORacleDBName]..[SIDName].[OracleTable] But now I don't know how to update oracle db from SQL. Pleas help me.

[Lost User]

Use the SQL UPDATE Statement[^].

[hmanhha]

I also want to create a new table in oracle DB through SQL Server such as. Select * from SQL Server into OracleLinkDB.

[Lost User]

I would suggest you study the documentation for both Oracle and SQL.

[Mycroft Holmes]

If you follow the link Richard supplied and look down the left menu - 18 items down you will find some interesting reading. You need to learn to do some thinking and research on your own!

Never underestimate the power of human stupidity RAH

[Jorgen Andersson]

Select * from SQL Server into OracleLinkDB is SQL Server Syntax. Oracles syntax is CREATE TABLE new_table AS (SELECT * FROM old_table); I'd recommend checking out techonthenet.com[^] for comparing the syntax of different databases.

Wrong is evil and must be defeated. - Jeff Ello

[hmanhha]

I Mean I Want to update Oracle DB through SQL Server Management Studio via Link Server.