日期:2014-05-17  浏览次数:21312 次

错误信息(923:ORA-00923: 未找到要求的 FROM 关键字
这是sql语句
"SELECT A.GROUP_NO,\n" + 
"       A.QTY_DATE,\n" + 
"       A.SEQ_ID,\n" + 
"       A.INNER_NO,\n" + 
"       A.SINGLE_BATTERY_NUM,\n" + 
"       A.MADE_DATE,\n" + 
"       A.LOT_NO,\n" + 
"       A.ASSET_NO,\n" + 
"       A.PRODUCT_NO,\n" + 
"       A.MADE_NO,\n" + 
"       A.PR_ORG,\n" + 
"       A.FIRST_RUN_DATE,\n" + 
"       A.LAST_RUN_DATE,\n" + 
"       A.LAST_REPAIR_DATE,\n" + 
"       A.CHIP_FACTORY,\n" + 
"       A.BATTERY_SHAPE,\n" + 
"       A.CHIP_GROUP_TYPE,\n" + 
"       (SELECT ORG_NAME FROM O_ORG WHERE ORG_NO = A.PR_ORG) PR_ORG_NAME,\n" + 
"       A.BELONG_DEPT,\n" + 
"       A.EQIP_PRC,\n" + 
"       N + A.PR_CODE,\n" + 
"       A.CUR_STATUS_CODE,\n" + 
"       A.DOC_CREATOR_NO,\n" + 
"       SUBS_ID,\n" + 
"       (SELECT SUBS_NO FROM C_SUBS WHERE SUBS_ID = A.SUBS_ID) SUBS_NO,\n" + 
"       + (SELECT USER_NAME N +\n" + 
"           FROM P_SYS_USER N +\n" + 
"          WHERE SYS_USER_NAME = A.DOC_CREATOR_NO) DOC_CREATOR_NAME,\n" + 
"       A.DOC_CREATE_DATE,\n" + 
"       N + A.REMARK,\n" + 
"       A.BATTERY_ID,\n" + 
"       A.GROUP_TYPE,\n" + 
"       A.BATTERY_TYPE,\n" + 
"       A.BATTERY_MODEL,\n" +