SELECT T.accname,
T.certinum,
T.accnum,
T.accphone,
T.uintaccname,
T.UNITACCNUM,
T.deputyname,
T.UNITPHONE,
T20.AJLXMC,
T21.AJSYMC,
U.USERNAME,
D.ORGNAME,
TO_CHAR(T.ACCEPTANCEDATE, 'yyyy-mm-dd'),
T.acceptanceid,
(SELECT U.USERNAME FROM ZF_USER U WHERE U.LOGINID = TAB.OPENOPERID) OPENOPERID,
CASE T2.REGISTER
WHEN '0' THEN
'否'
WHEN '1' THEN
'是'
ELSE
''
END,
TO_CHAR(T2.ACCEPTANCEDATE, 'yyyy-mm-dd'),
TO_CHAR(T2.MODIDATE, 'yyyy-mm-dd'),
(SELECT flowstepname FROM zf102 WHERE flowid = UV.CURFLOW) flowstepname,
CASE T2.CASSTAT
WHEN '0' THEN
'不立案'
WHEN '1' THEN
'立案中'
WHEN '2' THEN
'已立案'
WHEN '3' THEN
'執法中'
WHEN '4' THEN
'執法完成'
ELSE
''
END,
CASE T2.ASTAT
WHEN '0' THEN
'正常'
WHEN '1' THEN
'中止'
WHEN '2' THEN
'移交'
WHEN '7' THEN
'撤消'
WHEN '8' THEN
'退回'
WHEN '9' THEN
'辦結'
ELSE
''
END
FROM ZF001 T,
ZF002 T2,
ZF_USER U,
ZF_DEPARTMENT D,
ZF008 UV,
ZF020 T20,
ZF021 T21,
ZF102 Z1,
(SELECT T.ISID, T3.ACCEPTANCEID, T.OPENOPERID, U.USERNAME
FROM ZF010 T, ZF003 T3, ZF_USER U
WHERE T.ISID IN (SELECT MAX(T.ISID)
FROM ZF010 T, ZF003 T3
WHERE T3.ISID = T.ISID
GROUP BY T3.ACCEPTANCEID)
AND T3.ISID = T.ISID
AND T.OPENOPERID = U.LOGINID) TAB
WHERE T.ACCEPTANCEID = T2.ACCEPTANCEID
AND TAB.ACCEPTANCEID = T.ACCEPTANCEID
AND UV.ACCEPTANCEID = T.ACCEPTANCEID
AND T.OPERID = U.LOGINID
AND Z1.FLOWID = T2.FLOWID
AND T.accepttype = T20.AJLXID
AND T21.AJLXID = T20.AJLXID
AND T.REASON = T21.AJSYID
AND DECODE(T2.OPERORGID, NULL, T.PRGID, T2.OPERORGID) = D.ORGID
AND DECODE(T2.OPERORGID, NULL, T.PRGID, T2.OPERORGID) = '1001'
AND UV.SENDTIME1 >= TO_DATE('2018-01-01', 'YYYY-MM-DD hh24:mi:ss')
AND UV.SENDTIME1 <= TO_DATE('2019-01-01', 'YYYY-MM-DD hh24:mi:ss') + 1
SELECT T.accname,
T.certinum,
T.accnum,
T.accphone,
T.uintaccname,
T.UNITACCNUM,
T.deputyname,
T.UNITPHONE,
T20.AJLXMC,
T21.AJSYMC,
U.USERNAME,
D.ORGNAME,
TO_CHAR(T.ACCEPTANCEDATE, 'yyyy-mm-dd'),
T.acceptanceid,
(SELECT U.USERNAME FROM ZF_USER U WHERE U.LOGINID = TAB.OPENOPERID) OPENOPERID,
CASE T2.REGISTER
WHEN '0' THEN
'否'
WHEN '1' THEN
'是'
ELSE
''
END,
TO_CHAR(T2.ACCEPTANCEDATE, 'yyyy-mm-dd'),
TO_CHAR(T2.MODIDATE, 'yyyy-mm-dd'),
(SELECT flowstepname FROM zf102 WHERE flowid = UV.CURFLOW) flowstepname,
CASE T2.CASSTAT
WHEN '0' THEN
'不立案'
WHEN '1' THEN
'立案中'
WHEN '2' THEN
'已立案'
WHEN '3' THEN
'執法中'
WHEN '4' THEN
'執法完成'
ELSE
''
END,
CASE T2.ASTAT
WHEN '0' THEN
'正常'
WHEN '1' THEN
'中止'
WHEN '2' THEN
'移交'
WHEN '7' THEN
'撤消'
WHEN '8' THEN
'退回'
WHEN '9' THEN
'辦結'
ELSE
''
END
FROM ZF001 T,
ZF002 T2,
ZF_USER U,
ZF_DEPARTMENT D,
ZF008 UV,
ZF020 T20,
ZF021 T21,
ZF102 Z1,
(SELECT T.ISID, T3.ACCEPTANCEID, T.OPENOPERID, U.USERNAME
FROM ZF010 T, ZF003 T3, ZF_USER U
WHERE T.ISID IN (SELECT MAX(T.ISID)
FROM ZF010 T, ZF003 T3
WHERE T3.ISID = T.ISID
GROUP BY T3.ACCEPTANCEID)
AND T3.ISID = T.ISID
AND T.OPENOPERID = U.LOGINID) TAB
WHERE T.ACCEPTANCEID = T2.ACCEPTANCEID
AND TAB.ACCEPTANCEID = T.ACCEPTANCEID
AND UV.ACCEPTANCEID = T.ACCEPTANCEID
AND T.OPERID = U.LOGINID
AND Z1.FLOWID = T2.FLOWID
AND T.accepttype = T20.AJLXID
AND T21.AJLXID = T20.AJLXID
AND T.REASON = T21.AJSYID
AND DECODE(T2.OPERORGID, NULL, T.PRGID, T2.OPERORGID) = D.ORGID
AND DECODE(T2.OPERORGID, NULL, T.PRGID, T2.OPERORGID) = '1001'
AND UV.SENDTIME2 >= TO_DATE('2018-01-01', 'YYYY-MM-DD hh24:mi:ss')
AND UV.SENDTIME2 <= TO_DATE('2019-01-01', 'YYYY-MM-DD hh24:mi:ss') + 1
SELECT T.accname,
T.certinum,
T.accnum,
T.accphone,
T.uintaccname,
T.UNITACCNUM,
T.deputyname,
T.UNITPHONE,
T20.AJLXMC,
T21.AJSYMC,
U.USERNAME,
D.ORGNAME,
TO_CHAR(T.ACCEPTANCEDATE, 'yyyy-mm-dd'),
T.acceptanceid,
(SELECT U.USERNAME FROM ZF_USER U WHERE U.LOGINID = TAB.OPENOPERID) OPENOPERID,
CASE T2.REGISTER
WHEN '0' THEN
'否'
WHEN '1' THEN
'是'
ELSE
''
END,
TO_CHAR(T2.ACCEPTANCEDATE, 'yyyy-mm-dd'),
TO_CHAR(T2.MODIDATE, 'yyyy-mm-dd'),
(SELECT flowstepname FROM zf102 WHERE flowid = UV.CURFLOW) flowstepname,
CASE T2.CASSTAT
WHEN '0' THEN
'不立案'
WHEN '1' THEN
'立案中'
WHEN '2' THEN
'已立案'
WHEN '3' THEN
'執法中'
WHEN '4' THEN
'執法完成'
ELSE
''
END,
CASE T2.ASTAT
WHEN '0' THEN
'正常'
WHEN '1' THEN
'中止'
WHEN '2' THEN
'移交'
WHEN '7' THEN
'撤消'
WHEN '8' THEN
'退回'
WHEN '9' THEN
'辦結'
ELSE
''
END
FROM ZF001 T,
ZF002 T2,
ZF_USER U,
ZF_DEPARTMENT D,
ZF008 UV,
ZF020 T20,
ZF021 T21,
ZF102 Z1,
(SELECT T.ISID, T3.ACCEPTANCEID, T.OPENOPERID, U.USERNAME
FROM ZF010 T, ZF003 T3, ZF_USER U
WHERE T.ISID IN (SELECT MAX(T.ISID)
FROM ZF010 T, ZF003 T3
WHERE T3.ISID = T.ISID
GROUP BY T3.ACCEPTANCEID)
AND T3.ISID = T.ISID
AND T.OPENOPERID = U.LOGINID) TAB
WHERE T.ACCEPTANCEID = T2.ACCEPTANCEID
AND TAB.ACCEPTANCEID = T.ACCEPTANCEID
AND UV.ACCEPTANCEID = T.ACCEPTANCEID
AND T.OPERID = U.LOGINID
AND Z1.FLOWID = T2.FLOWID
AND T.accepttype = T20.AJLXID
AND T21.AJLXID = T20.AJLXID
AND T.REASON = T21.AJSYID
AND DECODE(T2.OPERORGID, NULL, T.PRGID, T2.OPERORGID) = D.ORGID
AND DECODE(T2.OPERORGID, NULL, T.PRGID, T2.OPERORGID) = '1001'
AND UV.SENDTIME5 >= TO_DATE('2018-01-01', 'YYYY-MM-DD hh24:mi:ss')
AND UV.SENDTIME5 <= TO_DATE('2019-01-01', 'YYYY-MM-DD hh24:mi:ss') + 1
uj5u.com熱心網友回復：
這三條sql就是同一個表的三個同型別欄位作為條件，然后用SENDTIME5的可以查詢出來，用SENDTIME1和SENDTIME2的查詢不出，不知道什么問題，這三個型別都是dateuj5u.com熱心網友回復：
uj5u.com熱心網友回復：
查不出的執行計劃
uj5u.com熱心網友回復：
你這種問題要一個一個地方的查。可能問題是 你的 in（后面結果有null值，導致結果不對）
轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/48207.html
標籤：開發
上一篇：介紹三個開發技術小知識點
下一篇：請幫忙看看這個觸發器是什么意思