The SET SERVEROUTPUT Command : SERVEROUTPUT « SQL Plus « Oracle PL / SQL

1. Oracle PL / SQL
2. SQL Plus
3. SERVEROUTPUT

The SET SERVEROUTPUT Command

  

SQL> SET SERVEROUTPUT ON
SQL> BEGIN
  2      dbms_output.put_line('This is the first line');
  3      dbms_output.put_line('This is the second line');
  4      dbms_output.put_line('This is the last line');
  5  END;
  6  /
This is the first line
This is the second line
This is the last line

PL/SQL procedure successfully completed.

   
  

Related examples in the same category