A small buffer : dbms_output « System Packages « Oracle PL / SQL






A small buffer

   
SQL>
SQL> SET ECHO ON
SQL> SET SERVEROUTPUT ON
SQL>
SQL> BEGIN
  2    DBMS_OUTPUT.ENABLE (2000);
  3
  4    DBMS_OUTPUT.PUT_LINE('Three names will be written.');
  5    DBMS_OUTPUT.PUT('J');
  6    DBMS_OUTPUT.NEW_LINE;
  7    DBMS_OUTPUT.PUT('S');
  8    DBMS_OUTPUT.NEW_LINE;
  9    DBMS_OUTPUT.PUT('T');
 10    DBMS_OUTPUT.NEW_LINE;
 11  END;
 12  /
Three names will be written.
J
S
T

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.dbms_output.new_line
11.DBMS_OUTPUT.NEW_LINE: a new line sign
12.Use DBMS_OUTPUT.PUT_LINE to output clob data
13.Use DBMS_OUTPUT.PUT_LINE to output the table collection indexed by BINARY_INTEGER
14.This script demonstrates the DBMS_OUTPUT package
15.Output Visual line break