一日一学！

DECLARE V_CNT NUMBER := 100; BEGIN DBMS_OUTPUT.ENABLE; LOOP INSERT INTO EMP(EMPNO, ENAME, HIREDATE) VALUES (V_CNT, 'TEST' || TO_CHAR(V_CNT), SYSDATE); ...

CREATE OR REPLACE PROCEDURE EXPCURSOR_TEST ( V_DEPTNO IN DEPT.DEPTNO%TYPE ) IS -- 声明CURSOR CURSOR DEPT_AVG IS SELECT B.DNAME AS DNAME , COUNT(A.EMP...

CREATE OR REPLACE PROCEDURE WHERE_CURRENT IS CURSOR EMP_LIST IS SELECT EMPNO , ENAME , SAL FROM EMP WHERE EMPNO = 1000 FOR UPDATE...