提示
[Err] ORA-00933: SQL 命令未正确结束
SELECT C.DEP_NAME,
B.USER_ID,
A.COMB_HEAD_NAME,
B.NAME NAME,
'个人' AS 个人团体,
COUNT(A.REGED_SERIAL_NO) QUANTITY,
ROUND((RATIO_TO_REPORT(COUNT(A.REGED_SERIAL_NO)) OVER()), 4) RATIO_QUANTITY
FROM (SELECT A.REGED_SERIAL_NO,
A.DEP_CODE,
A.CREATER_CODE,
A.COMB_HEAD_NAME,
H.ORG_CODE,
MAX(A.UPDATE_TIME) UPDATE_TIME
FROM T_PERSON_COMB A,T_PERSON_REG_INFO H
WHERE A.REGED_SERIAL_NO=H.SERIAL_NO
AND A.INVALID_FLAG = '0'
AND A.FINISH_FLAG = 1
AND A.CREATER_CODE > 40
AND H.ORG_CODE!=0
--AND TO_CHAR(A.UPDATE_TIME, 'YYYY.MM.DD') --BETWEEN '??txtTimeStart' AND
-- '??txtTimeEnd'
GROUP BY A.REGED_SERIAL_NO, A.DEP_CODE, A.CREATER_CODE,A.COMB_HEAD_NAME,H.ORG_CODE) A,
T_SYS_USER B,
T_BASE_DEP C
WHERE A.CREATER_CODE = B.USER_ID
AND C.DEP_ID = A.DEP_CODE
GROUP BY C.DEP_NAME, B.USER_ID, B.NAME,A.COMB_HEAD_NAME
ORDER BY C.DEP_NAME,B.USER_ID, B.NAME, A.COMB_HEAD_NAME
UNION
SELECT C.DEP_NAME,
B.USER_ID,
A.COMB_HEAD_NAME,
B.NAME NAME,
'团体' AS 个人团体,
COUNT(A.REGED_SERIAL_NO) QUANTITY,
ROUND((RATIO_TO_REPORT(COUNT(A.REGED_SERIAL_NO)) OVER()), 4) RATIO_QUANTITY
FROM (SELECT A.REGED_SERIAL_NO,
A.DEP_CODE,
A.CREATER_CODE,
A.COMB_HEAD_NAME,
H.ORG_CODE,
MAX(A.UPDATE_TIME) UPDATE_TIME
FROM T_PERSON_COMB A,T_PERSON_REG_INFO H
WHERE A.REGED_SERIAL_NO=H.SERIAL_NO
AND A.INVALID_FLAG = '0'
AND A.FINISH_FLAG = 1
AND A.CREATER_CODE > 40
AND H.ORG_CODE=0
--AND TO_CHAR(A.UPDATE_TIME, 'YYYY.MM.DD') --BETWEEN '??txtTimeStart' AND
-- '??txtTimeEnd'
GROUP BY A.REGED_SERIAL_NO, A.DEP_CODE, A.CREATER_CODE,A.COMB_HEAD_NAME,H.ORG_CODE) A,
T_SYS_USER B,
T_BASE_DEP C
WHERE A.CREATER_CODE = B.USER_ID
AND C.DEP_ID = A.DEP_CODE
GROUP BY C.DEP_NAME, B.USER_ID, B.NAME,A.COMB_HEAD_NAME
ORDER BY C.DEP_NAME,B.USER_ID, B.NAME, A.COMB_HEAD_NAME
[Err] ORA-00933: SQL 命令未正确结束
SELECT C.DEP_NAME,
B.USER_ID,
A.COMB_HEAD_NAME,
B.NAME NAME,
'个人' AS 个人团体,
COUNT(A.REGED_SERIAL_NO) QUANTITY,
ROUND((RATIO_TO_REPORT(COUNT(A.REGED_SERIAL_NO)) OVER()), 4) RATIO_QUANTITY
FROM (SELECT A.REGED_SERIAL_NO,
A.DEP_CODE,
A.CREATER_CODE,
A.COMB_HEAD_NAME,
H.ORG_CODE,
MAX(A.UPDATE_TIME) UPDATE_TIME
FROM T_PERSON_COMB A,T_PERSON_REG_INFO H
WHERE A.REGED_SERIAL_NO=H.SERIAL_NO
AND A.INVALID_FLAG = '0'
AND A.FINISH_FLAG = 1
AND A.CREATER_CODE > 40
AND H.ORG_CODE!=0
--AND TO_CHAR(A.UPDATE_TIME, 'YYYY.MM.DD') --BETWEEN '??txtTimeStart' AND
-- '??txtTimeEnd'
GROUP BY A.REGED_SERIAL_NO, A.DEP_CODE, A.CREATER_CODE,A.COMB_HEAD_NAME,H.ORG_CODE) A,
T_SYS_USER B,
T_BASE_DEP C
WHERE A.CREATER_CODE = B.USER_ID
AND C.DEP_ID = A.DEP_CODE
GROUP BY C.DEP_NAME, B.USER_ID, B.NAME,A.COMB_HEAD_NAME
ORDER BY C.DEP_NAME,B.USER_ID, B.NAME, A.COMB_HEAD_NAME
UNION
SELECT C.DEP_NAME,
B.USER_ID,
A.COMB_HEAD_NAME,
B.NAME NAME,
'团体' AS 个人团体,
COUNT(A.REGED_SERIAL_NO) QUANTITY,
ROUND((RATIO_TO_REPORT(COUNT(A.REGED_SERIAL_NO)) OVER()), 4) RATIO_QUANTITY
FROM (SELECT A.REGED_SERIAL_NO,
A.DEP_CODE,
A.CREATER_CODE,
A.COMB_HEAD_NAME,
H.ORG_CODE,
MAX(A.UPDATE_TIME) UPDATE_TIME
FROM T_PERSON_COMB A,T_PERSON_REG_INFO H
WHERE A.REGED_SERIAL_NO=H.SERIAL_NO
AND A.INVALID_FLAG = '0'
AND A.FINISH_FLAG = 1
AND A.CREATER_CODE > 40
AND H.ORG_CODE=0
--AND TO_CHAR(A.UPDATE_TIME, 'YYYY.MM.DD') --BETWEEN '??txtTimeStart' AND
-- '??txtTimeEnd'
GROUP BY A.REGED_SERIAL_NO, A.DEP_CODE, A.CREATER_CODE,A.COMB_HEAD_NAME,H.ORG_CODE) A,
T_SYS_USER B,
T_BASE_DEP C
WHERE A.CREATER_CODE = B.USER_ID
AND C.DEP_ID = A.DEP_CODE
GROUP BY C.DEP_NAME, B.USER_ID, B.NAME,A.COMB_HEAD_NAME
ORDER BY C.DEP_NAME,B.USER_ID, B.NAME, A.COMB_HEAD_NAME