dbms_output.new_line : DBMS_OUTPUT « System Packages « Oracle PL/SQL Tutorial






  1. Oracle PL/SQL Tutorial
  2. System Packages
  3. DBMS_OUTPUT
SQL>
SQL>
SQL> -------------------------------
SQL> set serveroutput on
SQL> set lines 200
SQL> -------------------------------
SQL> DECLARE
  2      BEGIN
  3          dbms_output.enable(200000) ;
  4          dbms_output.new_line ;
  5          dbms_output.new_line ;
  6      END ;
  7  /

PL/SQL procedure successfully completed.

SQL>








31.17.DBMS_OUTPUT
31.17.1.DBMS_OUTPUT.CHARARR
31.17.2.q for quotation with []
31.17.3.Output character or line
31.17.4.Output varchar variable
31.17.5.EXECUTE DBMS_OUTPUT.ENABLE(10000)
31.17.6.Use DBMS_OUTPUT.PUT_LINE to output clob data
31.17.7.Use DBMS_OUTPUT.PUT_LINE to output the table collection indexed by BINARY_INTEGER
31.17.8.Call substr in DBMS_OUTPUT.PUT_LINE
31.17.9.Output Visual line break
31.17.10.dbms_output.new_line
31.17.11.Output employee name with pl/sql, cursor and dbms_output.put_line