CREATE MATERIALIZED VIEW Employee_Incentive REFRESH COMPLETE START WITH SYSDATE NEXT SYSDATE + 1 AS select FIRST_NAME,INCENTIVE_DATE,INCENTIVE_AMOUNT from EMPLOYEE a, INCENTIVES b where a.EMPLOYEE_ID=b.EMPLOYEE_REF_ID