未来星开发团队的官网

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 费元星的博客 阅读(...) 评论(...) 编辑 收藏
未来星开发团队的官网