SQL ORA-00923 [message #19513] |
Fri, 22 March 2002 10:09 |
jt
Messages: 3 Registered: December 2000
|
Junior Member |
|
|
I keep getting a SQL error, ORA-00923,FROM keyword not found where expected. Can anyone tell me where my error is being made? Thank you!
SELECT TRADE_LOCAL_DATE, EUREX_COMMOD_CODE, TRADE_QUANTITY, BUY_EUREX_ORDER_ID, BUY_BOTCC_FIRM_NO, BUY_CTI_CODE, BUY_ORDER_TYPE
FROM
(SELECT TRADE_LOCAL_DATE, TRADE_LOCAL_TIME, EUREX_COMMOD_CODE, SUM (Q) TRADE_QUANTITY, BUY_EUREX_ORDER_ID, BUY_BOTCC_FIRM_NO, BUY_CTI_CODE, BUY_ORDER_TYPE
FROM
(SELECT EUREX_TRADE.TRADE_LOCAL_DATE, EUREX_TRADE.TRADE_LOCAL_TIME, EUREX_TRADE.EUREX_COMMOD_CODE, SUM (Q) EUREX_TRADE.TRADE_QUANTITY, EUREX_TRADE.BUY_EUREX_ORDER_ID, EUREX_TRADE.BUY_BOTCC_FIRM_NO, EUREX_TRADE.BUY_CTI_CODE, EUREX_TRADE.BUY_ORDER_TYPE
FROM EUREX_ADM.EUREX_TRADE EUREX_TRADE
WHERE ( UPPER(EUREX_TRADE.TRADE_LOCAL_TIME) BETWEEN UPPER('07200000') AND UPPER('13595999') ) AND ( EUREX_TRADE.EUREX_COMMOD_CODE = 'ZF' ) AND ( EUREX_TRADE.TRADE_LOCAL_DATE BETWEEN TO_DATE('20020213000000','YYYYMMDDHH24MISS') AND TO_DATE('20020213000000','YYYYMMDDHH24MISS') GROUP BY EUREX_TRADE.TRADE_LOCAL_DATE, EUREX_TRADE.EUREX_COMMOD_CODE, EUREX_TRADE.BUY_CTI_CODE, EUREX_TRADE.BUY_BOTCC_FIRM_NO,EUREX_TRADE.BUY_EUREX_ORDER_ID, EUREX_TRADE.BUY_ORDER_TYPE
)
GROUP BY EUREX_TRADE.TRADE_LOCAL_DATE, EUREX_TRADE.EUREX_COMMOD_CODE, EUREX_TRADE.BUY_CTI_CODE, EUREX_TRADE.BUY_BOTCC_FIRM_NO,EUREX_TRADE.BUY_EUREX_ORDER_ID, EUREX_TRADE.BUY_ORDER_TYPE
)
ORDER BY EUREX_TRADE.TRADE.TRADE_LOCAL_DATE, EUREX_TRADE.BUY_BOTCC_FIRM_NO, EUREX_TRADE.EUREX_COMMOD_CODE
|
|
|
Re: SQL ORA-00923 [message #19514 is a reply to message #19513] |
Fri, 22 March 2002 13:45 |
Mike
Messages: 417 Registered: September 1998
|
Senior Member |
|
|
I think there is a missing right parenthesis in:
... AND ( EUREX_TRADE.TRADE_LOCAL_DATE BETWEEN TO_DATE('20020213000000','YYYYMMDDHH24MISS') AND TO_DATE('20020213000000'...
the condition:
EUREX_TRADE.TRADE_LOCAL_DATE BETWEEN TO_DATE('20020213000000','YYYYMMDDHH24MISS')
has only a left parentheses at its begining but no right one at the end.
Correct would be:
... AND ( EUREX_TRADE.TRADE_LOCAL_DATE BETWEEN TO_DATE('20020213000000','YYYYMMDDHH24MISS') ) AND TO_DATE('20020213000000'...
HTH
Mike
|
|
|