在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;

未完待续。。。