摘要:
--3.查询10部门所有员工的姓名。(ref游标实现) 动态游标 declare --创建一种游标类型 type type_cursor is ref cursor; --声明变量指定游标类型 v_cur type_cursor; v_ename emp.ename%type; begin open 阅读全文
摘要:
declare v_ename emp.ename%type; begin select ename into v_ename from emp where empno=&gno; dbms_output.put_line('名字:'||v_ename); exception when no_dat 阅读全文
摘要:
select * from (select rownum rn,e2.* from (select e1.* from emp e1)e2 where rownum<=10)e3 where e3.rn>=6; select * from (select rownum en,e.* from emp 阅读全文
摘要:
##if-else运用 declare v_num number(8); begin v_num :=&n; if v_num>0 and v_num<100 then dbms_output.put_line('工薪阶级'); elsif v_num between 100 and 200 the 阅读全文