摘要:
select deptno ,wm_concat(ename) from emp GROUP BY deptno;--行转列 阅读全文
摘要:
set serveroutput on; declare cursor c1 is select dno,dname from dep; pdno dep.dno%TYPE; pdname dep.dname%type; cursor c2(aa varchar2,bb number) is select grade from sc where cno=(select cno from... 阅读全文
摘要:
declare cursor cemp is select empno ,sal from emp order by sal; --定义参数 pempno emp.empno%type; psal emp.sal%type; countEmp number :=0; salTotal number; begin --得到工资总额的初始值 ... 阅读全文
摘要:
set serveroutput on DECLARE cursor cemp is select to_char(hiredate,'yyyy') from emp ; phiredate varchar2(8); count80 number :=0; count81 number:=0; count82 number:=0; count87 number:=0; begin ope... 阅读全文
摘要:
set serveroutput on DECLARE cursor cemp is select ename from emp where deptno=50; pename emp.ename%type; --自定义异常 no_emp_found exception; begin open cemp; fetch cemp into pename; if cemp%n... 阅读全文
摘要:
set serveroutput on DECLARE pename emp.ename%type; begin select ename into pename from emp where ename='1213'; exception when no_data_found then dbms_output.put_line('没有该数据'); when others th... 阅读全文