This script demonstrates the DBMS_OUTPUT package : dbms_output « System Packages « Oracle PL / SQL






  1. Oracle PL / SQL
  2. System Packages
  3. dbms_output

This script demonstrates the DBMS_OUTPUT package

  
SQL>
SQL> set feedback on
SQL> set pages 9999 serveroutput off
SQL>
SQL> BEGIN
  2     DBMS_OUTPUT.PUT_LINE('Oh...');
  3  END;
  4  /

PL/SQL procedure successfully completed.

SQL>
SQL>
SQL> set serveroutput on
SQL>
SQL> /
Oh...

PL/SQL procedure successfully completed.

SQL>
SQL>








Related examples in the same category

1.Displaying Hello World! to the Screen
2.Call dbms_output.disable
3.Call dbms_output.put_line to display text message
4.dbms_output.enable
5.EXECUTE DBMS_OUTPUT.ENABLE(10000)
6.dbms_output.put: display text without new line sign
7.Call dbms_output.new_line to create a new line
8.DBMS_OUTPUT.GET_LINES
9.Combine text and number in DBMS_OUTPUT.PUT_LINE
10.A small buffer
11.dbms_output.new_line
12.DBMS_OUTPUT.NEW_LINE: a new line sign
13.Use DBMS_OUTPUT.PUT_LINE to output clob data
14.Use DBMS_OUTPUT.PUT_LINE to output the table collection indexed by BINARY_INTEGER
15.Output Visual line break