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;
未完待续。。。
页:
[1]