以下语句在Oracle可以正常执行
SQL> SELECT RIGHT.GROUPRIGHTS,RULE.SEQUENCE,OPER.OPERATIONNO
FROM CHIP.MES_PRC_OPER OPER,
CHIP.MES_PRC_OPER_TYPE TYPE,
CHIP.MES_PRC_OPER_TYPE_RULE RULE,
CHIP.MES_SEC_RIGHT RIGHT; 2 3 4 5

no rows selected

在DM中提示语法错误
SQL> SELECT RIGHT.GROUPRIGHTS,RULE.SEQUENCE,OPER.OPERATIONNO
FROM MES_PRC_OPER OPER,
MES_PRC_OPER_TYPE TYPE,
MES_PRC_OPER_TYPE_RULE RULE,
MES_SEC_RIGHT RIGHT2 3 4 5 ;
SELECT RIGHT.GROUPRIGHTS,RULE.SEQUENCE,OPER.OPERATIONNO
FROM MES_PRC_OPER OPER,
MES_PRC_OPER_TYPE TYPE,
MES_PRC_OPER_TYPE_RULE RULE,
MES_SEC_RIGHT RIGHT;

     MES_SEC_RIGHT RIGHT;
                        *

line 5, column 29, nearby [;] has error[-2007]:
Syntax error.

做以下修改
SQL> SELECT RIGHT.GROUPRIGHTS,RULE.SEQUENCE,OPER.OPERATIONNO
FROM CHIP.MES_PRC_OPER “OPER”,
CHIP.MES_PRC_OPER_TYPE “TYPE”,
CHIP.MES_PRC_OPER_TYPE_RULE “RULE”,
CHIP.MES_SEC_RIGHT “RIGHT”;2 3 4 5
no rows

used time: 1.205(ms). Execute id is 53003.

触发器方面
DM中REFERENCING OLD AS OLD NEW AS NEW有顺序要求

REFERENCING OLD AS OLD NEW AS NEW 正确
REFERENCING NEW AS NEW OLD AS OLD 错误