ORACLE PL/SQL练习（四）

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

未完待续。。。