在SQL*Plus里输入并执行PL/SQL块


DECLARE

-- Some cursor and variables declarations

BEGIN

DBMS_OUTPUT.PUT_LINE('HELLO WORLD');

END;

/


接受用户从键盘输入

DECLARE

  emp_count NUMBER;

BEGIN

  SELECT COUNT(*)

    INTO emp_count

    FROM EMPLOYEES

   WHERE department_id = &department_id;

END;


未完待续。。。