摘要:
create or replace procedure p1(p_sal1 number,p_sal2 number,p_con out number)isbegin select count(*) into p_con from emp where sal between p_sal1 and p 阅读全文
摘要:
create or replace procedure p1(p_deptno number,p_con out number)isbegin select count(*) into p_confrom empwhere sal > (select avg(sal) from emp where 阅读全文
摘要:
create or replace procedure p1(p_deptno number,p_avg_sal out number)is ex exception; cursor yb is select * from dept; flag number := 0;begin for r in 阅读全文