OraFAQ Forum: Networking and Gateways » how can i run the dml statement?

Home » RDBMS Server » Networking and Gateways » how can i run the dml statement?

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

how can i run the dml statement? [message #534411]

Mon, 05 December 2011 20:10

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.

Report message to a moderator

Re: how can i run the dml statement? [message #534412 is a reply to message #534411]

Mon, 05 December 2011 20:15

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

INSERT INTO NEW_TABLE@SQL_SERVER SELECT * FROM OLD_TABLE;

Report message to a moderator

Re: how can i run the dml statement? [message #534439 is a reply to message #534412]

Tue, 06 December 2011 02:49

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.

Report message to a moderator

Re: how can i run the dml statement? [message #534440 is a reply to message #534439]

Tue, 06 December 2011 02:50

lonion
Messages: 97
Registered: August 2011
Location: shenzhen,China

Member

when using udpate or where clause

Report message to a moderator

Re: how can i run the dml statement? [message #534442 is a reply to message #534440]

Tue, 06 December 2011 02:59

Michel Cadot
Messages: 68757
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun May 04 22:27:15 CDT 2025