Monday 11 March 2019

How to refresh Materialized view

Here is the sample script to refresh the materialized view.


DECLARE
BEGIN
  DBMS_MVIEW.refresh('EMP_MV');    --'EMP_MV is the materialized view name.
END;

No comments:

Post a Comment