Oracle里的视图和物理视图--上

普通视图语法：

create or replace view view_name  as

      select  * from dual;

物理视图语法：

1、

CREATE MATERIALIZED VIEW view_name
     REFRESH FORCE ON DEMAND   --刷新视图规则
     START WITH TO_DATE('15-10-2011 23:57:11', 'DD-MM-YYYY HH24:MI:SS') NEXT SYSDATE + 1   ---刷新时间周期
   【ENABLE QUERY REWRITE 】
     AS
     select * from dual;

2、

create materialized view view_name
      refresh fast on commit
     【enable query rewrite 】
      as
      select * from dual;