我收到一个错误，"SQL command not properly ended"此查询

Question

SELECT 
HEADER_ID
FROM 
XXCORP.XXCORP_OM_DEALER_FEE_DIS_HDR as h, 
XXCORP.XXCORP_OM_DEALER_FEE_DIS_LIN,
OE_ORDER_HEADERS_ALL
WHERE h.FEE_ID = XXCORP_OM_DEALER_FEE_DIS_LIN.FEE_ID (+) 
AND h.HEADER_ID(+) = OE_ORDER_HEADERS_ALL.HEADER_ID 
AND (XXCORP.XXCORP_OM_DEALER_FEE_DIS_LIN.LAST_UPDATE_DATE > TO_DATE('03/10/2019 00:00:00', 'MM/DD/YYYY HH24:MI:SS'));

Answer 1

表名称不应具有AS的别名，这里：

XXCORP.XXCORP_OM_DEALER_FEE_DIS_HDR as h, 
                                    --
                                    this! --> remove "as"

说明它的示例：

SQL> select * From dept as d;
select * From dept as d
                   *
ERROR at line 1:
ORA-00933: SQL command not properly ended

SQL> select * from dept d;
    DEPTNO DNAME          LOC
---------- -------------- -------------
        10 ACCOUNTING     NEW YORK
        20 RESEARCH       DALLAS
        30 SALES          CHICAGO
        40 OPERATIONS     BOSTON
SQL>