参考资料：oracle物化视图总结
create materialized view TEMP_MV refresh complete on demand start with to_date(‘25-10-2020 23:50:00‘, ‘dd-mm-yyyy hh24:mi:ss‘) next trunc(sysdate+1,‘dd‘)+interval ‘23:50:00‘ hour to second as select * from temp
2022-02-15 01:00:16
参考资料：oracle物化视图总结
create materialized view TEMP_MV refresh complete on demand start with to_date(‘25-10-2020 23:50:00‘, ‘dd-mm-yyyy hh24:mi:ss‘) next trunc(sysdate+1,‘dd‘)+interval ‘23:50:00‘ hour to second as select * from temp