关于视图1、什么是视图视图实际上是一条查询语句，是数据的显示方式2、视图的作用安全方便一致性例子1：create or replace view myviewasselect * from abc;
例子2：设定检测添加数据create or replace view myviewasselect * from abc where C>=100with check option/
例子3：两表合并查询create or replace view v_dasselect e.eid,e.ename,e.sex,d.name from e,d where
e.id=d.id;
例子4：with read only只能读create or replace view v_readasselect eid,ename from empwith read only;
查询 desc dba_views desc all_views desc user_views
select text from user_views where view_name='v_read';
相关资源：Oracle PL/SQL程序设计(第5版)源代码
