create materialized view VIEW_DEMO refresh force on demand start with to_date('17-06-2023 05:00:00', 'dd-mm-yyyy hh24:mi:ss') next TO_DATE(CONCAT(TO_CHAR(SYSDATE + 1,'DD-MM-YYYY'),' 05:00:00'),'DD-MM-YYYY HH24:MI:SS') as select sysdate from dual;
create materialized view VIEW_DEMO refresh force on demand start with to_date('17-06-2023 05:00:00', 'dd-mm-yyyy hh24:mi:ss') next TO_DATE(CONCAT(TO_CHAR(SYSDATE + 1,'DD-MM-YYYY'),' 05:00:00'),'DD-MM-YYYY HH24:MI:SS') as select sysdate from dual;