全部博文
-
编辑 删除
oracle游标
--while循环与游标的利用 SET SERVEROUTPUT ON DECLARE v_eno emp.empno%type; v_name emp.ename%type; CURSOR emp_sal_cur(p_no emp.sal%type) IS SELECT empno,ename FROM emp WHERE sal<p_no; BEGIN OPEN emp_sal_cur(3000); FETCH emp_sal_cur INTO v_eno,v_name; DBMS_OUTPUT.PUT_LINE(v_eno||" "||v_name); WHILE emp_sal_cur%FOUND LOOP &
