--------建立簡(jiǎn)單視圖

create view view_name

as

select * from 查詢語(yǔ)句

(建立視圖)

---------帶檢查約束的視圖

create view view_name

as

select * from 查詢語(yǔ)句

with check option

---------------只讀視圖

create or replace view view_name

as

select * from 查詢語(yǔ)句

with read only

--------創(chuàng)建帶錯(cuò)誤的視圖(適用于沒(méi)有表的情況下，先建立視圖)

create force view view_name

as

select * from 查詢語(yǔ)句