Home » RDBMS Server » Networking and Gateways » how can i run the dml statement?
how can i run the dml statement? [message #534411] Mon, 05 December 2011 20:10 Go to next message
lonion
Messages: 97
Registered: August 2011
Location: shenzhen,China
Member
how can i run dml statement on the oracle transparent gateway for sql server ,such as insert ,update,delete.

thank u for help.
Re: how can i run the dml statement? [message #534412 is a reply to message #534411] Mon, 05 December 2011 20:15 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
INSERT INTO NEW_TABLE@SQL_SERVER SELECT * FROM OLD_TABLE;
Re: how can i run the dml statement? [message #534439 is a reply to message #534412] Tue, 06 December 2011 02:49 Go to previous messageGo to next message
lonion
Messages: 97
Registered: August 2011
Location: shenzhen,China
Member
i found that the column name in the oracle must the same with the sql server.
Re: how can i run the dml statement? [message #534440 is a reply to message #534439] Tue, 06 December 2011 02:50 Go to previous messageGo to next message
lonion
Messages: 97
Registered: August 2011
Location: shenzhen,China
Member
when using udpate or where clause
Re: how can i run the dml statement? [message #534442 is a reply to message #534440] Tue, 06 December 2011 02:59 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
When referencing it, of course the name of the column should match with the one declared.
In Oracle that by default ignores the case, so you will have to put the between ":
select "MyColumn" from "MyTable"@SQL_SERVER;
Same thing for any statement.

Regards
Michel
Previous Topic: Problem connecting Forms to new Express 10g Server.
Next Topic: one listener or more listener?
Goto Forum:
  


Current Time: Thu Mar 28 16:01:29 CDT 2024