Output character or line : DBMS_OUTPUT « System Packages « Oracle PL/SQL Tutorial






  1. Oracle PL/SQL Tutorial
  2. System Packages
  3. DBMS_OUTPUT
SQL>
SQL> SET SERVEROUTPUT ON
SQL> BEGIN
  2     DBMS_OUTPUT.PUT(CHR(10));
  3     DBMS_OUTPUT.PUT_LINE('PRINT ME');
  4     DBMS_OUTPUT.PUT(CHR(10));
  5  END;
  6  /

PRINT ME

PL/SQL procedure successfully completed.








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