|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
SlickEdit: Code in over 40 languages across 7 platforms. SlickEdit’s unmatched power, speed, and flexibility allows even the most accomplished developers to write better code faster. Download a free trial today! |
|
#1
March 31st, 2004, 02:43 PM
|
|||
|
|||
|
ORA-00933 Error
Here is my update statement:
UPDATE REGMART.CORPS_ORG_DIM CO SET CO.MSC_NAME = ORG.NAME, CO.MSC_EROC = ORG.EROC, CO.MSC_SHORT_NAME = ORG.SHORT_NAME FROM REGULATOR.ORGANIZATIONS@DVL2 ORG WHERE CO.ID = ORG.ID; -------------------------------------------------- I am getting the following error at FROM in line 5: "ORA-00933: SQL Command not properly ended." As I said before the error is at the FROM in line 5. I have tried in both SQL Plus and TOAD. Any help is appreciated
|
|
#2
March 31st, 2004, 11:40 PM
|
|||
|
|||
|
Hi,
When you issue an update you define the table you are updating thus you do not need the from (and you cant use it). Galit.
|
|
| Viewing: Dev Shed Forums > Databases > Oracle Development > ORA-00933 Error |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
