使用前一天的数据并防止覆盖,逐级保存15条
where a.TBRQ
>=
(select case when TBRQ>=trunc(sysdate-1)
then trunc(sysdate-1)
else to_date('2023-03-31 00:00:00','yyyy-mm-dd hh24:mi:ss') end
from V_BA_MAX_TBRQ)
and rownum <
(select case when TBRQ>=trunc(sysdate-1)
then 2000
else
-- 24640- ('0'+to_char(sysdate, 'mm' )
-- ||
-- to_char(sysdate, 'dd' )
-- )*20
499- to_char(sysdate-1, 'dd' )*15
end
from V_BA_MAX_TBRQ)