黑马程序员Oracle数据库精讲，从0到1学会Oracle数据库

--------建立简单视图

create view view_name

as

select * from 查询语句

(建立视图)

---------带检查约束的视图

create view view_name

as

select * from 查询语句

with check option

---------------只读视图

create or replace view view_name

as

select * from 查询语句

with read only

--------创建带错误的视图(适用于没有表的情况下，先建立视图)

create force view view_name

as

select * from 查询语句