Shulou(Shulou.com)06/01 Report--

Enter and execute PL/SQL blocks in SQL*Plus

DECLARE

-- Some cursor and variables declarations

BEGIN

DBMS_OUTPUT.PUT_LINE ('HELLO WORLD')

END

/

Accept user input from the keyboard

DECLARE

Emp_count NUMBER

BEGIN

SELECT COUNT (*)

INTO emp_count

FROM EMPLOYEES

WHERE department_id = & department_id

END

To be continued.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.