ORACLE创建固化视图CREATE MATERIALIZED? VIEWMV_PersonREFRESH FORCE ON DEMAND ASselect * from User?如
ORACLE创建固化视图
CREATE MATERIALIZED? VIEW
MV_Person
REFRESH FORCE ON DEMAND AS
select * from User
?
如果我们想更亲固化视图里的数据,我们直接刷新 这个视图
?
BEGIN
??? DBMS_MVIEW.REFRESH(‘User’);
END;
