Materialized View in Oracle

Create Materialized View:

CREATE MATERIALIZED VIEW EMP_MVIEW
AS
SELECT * FROM EMP;

Refresh Materialized view:

EXEC DBMS_MVIEW.REFRESH ('EMP_MVIEW', method => 'C');

Drop Materialized View:

DROP MATERIALIZED VIEW EMP_MVIEW;