Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
wided
Posting Yak Master
218 Posts |
 Posted - 2011-05-26 : 05:26:04
|
| I'm working on 2 databases at the same time SQL and ORACLE I need to transfer data from the database oracle base sql First, I read oracle data that do not exist in my target database SQLhi select a, b, c from mydatabaseoracle.mytableoracle WHERE not exists (select * from maydatabasesql.mydatabasetable) the message that appears after the missing right parenthesis MESSAGE ora00907 I think it is when I read sql syntax, because I have no problem with syntax not exists if I read a table ORACLE |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2011-05-26 : 05:38:28
|
your query is running in Oracle right ? Then you should post your question in a oracle forum.
KH[spoiler]Time is always against us[/spoiler] |
 |
|
|
|
|
|
sql et oracle