视图:简单视图,复杂视图,物化视图。
注意:简单视图和复杂视图是不占磁盘空间。
创建:语法
create view() as select ()from () where ();
SQL> create view v1 as select * from dmhr.employee;
SQL> select view_name,text from dba_views where view_name='V1';
删除:
SQL> drop view v1;
视图:简单视图,复杂视图,物化视图。
注意:简单视图和复杂视图是不占磁盘空间。
创建:语法
create view() as select ()from () where ();
SQL> create view v1 as select * from dmhr.employee;
SQL> select view_name,text from dba_views where view_name='V1';
删除:
SQL> drop view v1;