视图同义词序列索引1
需积分: 0 143 浏览量
2022-08-08
21:21:53
上传
评论
收藏 5.52MB DOCX 举报
================================视图=======================
Grant create view to scott;
撤销权限
Revoke create view from scott;
create view emp_view2 as
select empno "编号",ename "姓名",sal "工资",sal*12 "年薪",sal*12+nvl(comm,0) "年收入"
from emp;
create or replace view emp_view3(a,b,c,d,e) as select empno "编号",ename "姓名",sal " 工资
",sal*12 "年薪",sal*12+nvl(comm,0) "年收入" from emp; 注意：
评论0
最新资源