未来星开发团队的官网

oracle 建立一个视图,然后授权其他用户访问

grant select on V_LIC_ENTRY_HZ_STATUS to ielicr2013;

 

create or replace view dept_sum_vw
(name,minsal,maxsal,avgsal)
as
select d.dname,min(e.sal),max(e.sal),avg(e.sal)
from emp e,dept d
where e.deptno=d.deptno
group by d.dname;

posted @ 2016-02-26 10:07  费元星的博客  阅读(9603)  评论(0编辑  收藏
未来星开发团队的官网