| 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.
|
|
|
|
|
|
|
|
|
|
| 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: 68734
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
