select * from (
select
case
when a.PROCESS_ID in ('101291','101508')then a.customer_sn
when a.PROCESS_ID in ('101509','101510') then a.serial_number
end as SN,
case
when a.PROCESS_ID in ('101291','101508') then b.fw_version_b
when a.PROCESS_ID = '101509' then b.fw_version_l
when a.PROCESS_ID = '101510' then b.fw_version_r
end as FW
from aa partition(P_C_202003) a
left join bb partition(P_A_202003) b on
(case
when a.PROCESS_ID in ('101291','101508')then a.customer_sn
when a.PROCESS_ID in ('101509','101510') then a.serial_number
end ) = b.sn
and (case
when a.PROCESS_ID in ('101291','101508') then b.fw_version_b
when a.PROCESS_ID = '101509' then b.fw_version_l
when a.PROCESS_ID = '101510' then b.fw_version_r
end ) is not null
where a.current_status=0
and a.process_id in ('101291','101509','101510','101508')
and a.out_process_time between to_date('2020-03-23 11:00:00','yyyy-mm-dd hh24:mi:ss')
and to_date('2020-03-23 19:00:00','yyyy-mm-dd hh24:mi:ss')
)
where FW is null;
SQL就是上面這個SQL,不用細看SQL邏輯有沒有問題（應該沒問題啥問題的）。問題就是如果去掉最后一行where FW is null資料可以查詢出來，加上where FW is null就會報ORA-03113: end-of-file on communication channel
uj5u.com熱心網友回復：
看看 alert日志有沒有其他錯誤資訊轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/16405.html
標籤：開發
上一篇：跪求大佬解題