如果希望对常见的Oracle异常ORA报错解决方案有系统的了解,请看《ORACLE系列异常总结ORA》。
ORA-01741: illegal zero-length identifier
正确SQL:
SELECT T.FID "id", T.FKTRANSACTSTEPID "transactStep.id", T.FSTEPENUM "stepEnum", T.FSTATUS "status", T.FACCEPTORENUM "acceptorEnum", T.FCONTENT "content", T.FOPINION "opinion", T.FKAUDITPERSONID "auditPerson.id", T.FKAUDITORGID "auditOrg.id", T.FKCREATEBYID "createBy.id", T.FCREATETIME "createTime", T.FKCUID "cu.id" FROM T_TRADE_TRANSFERSMSMODEL T WHERE T.FSTATUS != 'DELETED' |