Oracle 存储过程刷新物化视图SQL:
CREATE OR REPLACE PACKAGE BODY REFRESH_MVIEW IS
-- Author : 241433
-- Created : 12/2/2010 4:25:04 PM
-- Purpose : This PKG is for REFRESH MVIEW
-- Public type declarations
CONS_BCR_LIST VARCHAR2(40) := 'BCR_UI_BLOCK_LIST_ALL_VW';
CONS_BCR_LIST_QUERY VARCHAR2(40) := 'BCR_UI_BLOCK_LIST_QUERY_VW';
CONS_BCR_RULE VARCHAR2(40) := 'BCR_UI_BLOCK_RULE_ALL_VW';
CONS_CUST_HCP VARCHAR2(40) := 'CAPUBLISH.HCP_CUST_PROFILE_VW';
CONS_CUST_HCA VARCHAR2(40) := 'CAPUBLISH.HCA_CUST_PROFILE_VW';
PROCEDURE REFRESH_MVIEW(P_MVIEW_NAME IN VARCHAR2) IS
BEGIN
DBMS_MVIEW.REFRESH(P_MVIEW_NAME);
END REFRESH_MVIEW;
PROCEDURE REFRESH_MVIEW_BCR_REPORT IS
BEGIN
REFRESH_MVIEW(CONS_BCR_LIST);
REFRESH_MVIEW(CONS_BCR_LIST_QUERY);
REFRESH_MVIEW(CONS_BCR_RULE);
END REFRESH_MVIEW_BCR_REPORT;
PROCEDURE REFRESH_MVIEW_CUST IS
BEGIN
REFRESH_MVIEW(CONS_CUST_HCP);
REFRESH_MVIEW(CONS_CUST_HCA);
END REFRESH_MVIEW_CUST;
END REFRESH_MVIEW;