--参考:....
if to_date(begin_date,'yyyymmdd')>to_date(end_date,'yyyymmdd') then
RAISE_APPLICATION_ERROR(-20007,'起始日期大于结束日期!!!');
end if;
..........
if to_date(begin_date,'yyyymmdd')>to_date(end_date,'yyyymmdd') then
RAISE_APPLICATION_ERROR(-20007,'起始日期大于结束日期!!!');
end if;
..........
(
dno number
)
return number is
etotal number;
begin
select nvl(sum(sal),0) into etotal from emp where deptno=dno group by deptno;
return etotal;
end eshow;
/