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;

未来星开发团队--狒狒QQ:9715234
收藏 打印