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;
DECLARE
BEGIN
DBMS_MVIEW.refresh('EMP_MV'); --'EMP_MV is the materialized view name.
END;
No comments:
Post a Comment