Oracle/PL/SQL

Test the Output of a PL/SQL Block

Figo Kim 2006. 12. 31. 05:49

SET SERVEROUTPUT ON

 

DECLARE

f_name varchar(20);

 

BEGIN

SELECT first_name INTO f_name FROM employees WHERE employee_id = 100;

DBMS_OUTPUT.PUT_LINE(' The First Name of the Employee is '||f_name);

END;

PL/SQL doesn't have any functionality built in it.

  • Enable output in iSQL PLUS with the command
    SET SERVEROUTPUT ON
  • Use a predefined Oracle Package and its procedure
    DBMS_OUTPUT.PUT_LINE