oracle sql 基础

视图；

create or replace view my_view
 as
select * from books where id>30
with check option

往视图 插入数据 ，不符合id>30 ,无法插入成功

create or replace view my_view
 as
select * from books where id>30
with read only

-------------------------------------------------------------------------------