目录
创建,查询,修改,删除 视图
--创建视图
create or replace view v_1
as
select ename, hiredate, sal, dpetno
from EMP
WHERE DPETNO > 10;
-- 查询视图
SELECT ename, sal, dpetno
FROM v_1
where v_1.dpetno > 20;
-- SHOW CREATE VIEW v_1;
-- 修改视图
create or replace view v_1 as
select sal, dpetno
from EMP
where SAL > 500;
alter view v_1 as select sal, dpetno
from EMP
where SAL > 500;
-- 删除视图
drop view if exists v_1;
视图检查选项
create or replace view v_2 as select DPETNO,SAL from EMP where SAL>800 with local check option;
select * from v_2;
insert into EMP values(3213,'小组','1981-06-09',700,10);
insert into EMP values(3243,'小机','1981-06-10',900,,10);
不加检查会成功插入,但是视图查不到(效果不好 )
case传递 不满足会报错 依赖要去判断 级联要去判断