| ORA-00933: SQL command not properly ended [message #52709] |
Wed, 07 August 2002 16:27  |
Deryk Marien
Messages: 2
Registered: August 2002
|
Junior Member |
|
|
I am getting an error message when running this SQL Statement. Can anyone shed some light as to why I am getting this error?
QL> SELECT CS_EMPLOYEE.EMPLOYEE_ID,
2 CS_EMPLOYEE.VLD_PREV_TEMP_EMP_STATUS_CS_NM,
3 CS_EMPLOYEE.SOCIAL_SECURITY_NUMBER,
4 RV_EMPLOYEE_ADDRESS.ADDRESS_LINE_1,
5 RV_EMPLOYEE_ADDRESS.ADDRESS_LINE_2,
6 RV_EMPLOYEE_ADDRESS.CITY,
7 RV_EMPLOYEE_ADDRESS.STATE_PROV,
8 RV_EMPLOYEE_ADDRESS.ZIP_CODE,
9 RV_EMPLOYEE_ADDRESS.ADDRESS_TYPE
10 FROM CS_EMPLOYEE INNER JOIN RV_EMPLOYEE_ADDRESS ON
11 CS_EMPLOYEE.EMPLOYEE_ID =
12 RV_EMPLOYEE_ADDRESS.EMPLOYEE_ID
13 WHERE (CS_EMPLOYEE.VLD_PREV_TEMP_EMP_STATUS_CS_NM='WORK' Or
14 CS_EMPLOYEE.VLD_PREV_TEMP_EMP_STATUS_CS_NM='PAVL' Or
15 CS_EMPLOYEE.VLD_PREV_TEMP_EMP_STATUS_CS_NM='NEW' Or
16 CS_EMPLOYEE.VLD_PREV_TEMP_EMP_STATUS_CS_NM='AVAL')
17 ORDER BY
18 CS_EMPLOYEE.EMPLOYEE_ID,RV_EMPLOYEE_ADDRESS.ADDRESS_TYPE;
FROM CS_EMPLOYEE INNER JOIN RV_EMPLOYEE_ADDRESS ON
*
ERROR at line 10:
ORA-00933: SQL command not properly ended
|
|
|
|
|
|
| Re: ORA-00933: SQL command not properly ended [message #54356 is a reply to message #52733] |
Tue, 12 November 2002 11:55  |
Garrey Learmonth
Messages: 1
Registered: November 2002
|
Junior Member |
|
|
It's nothing to do with that - if you look at the code properly you will see there _is_ a semicolon at the end. The problem is syntactical and depends on what version of the DB you are running.
You may be trying to using SQL99 type syntax against a non-SQL99 version of Oracle. Check into this with your DBA.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
