DBMS_OUTPUT package : DBMS_OUTPUT « PL SQL « Oracle PL / SQL






  1. Oracle PL / SQL
  2. PL SQL
  3. DBMS_OUTPUT

DBMS_OUTPUT package

SQL>
SQL> -- DBMS_OUTPUT package
SQL>
SQL>
SQL>
SQL> SET SERVEROUTPUT ON
SQL> BEGIN
  2     DBMS_OUTPUT.PUT_LINE('Hello');
  3     DBMS_OUTPUT.PUT_LINE('there');
  4  END;
  5  /
Hello
there

PL/SQL procedure successfully completed.

SQL>
SQL>








Related examples in the same category

1.Print out value using DBMS_OUTPUT.PUT_LINE
2.Use dbms_output.put_line to display varchar2 type value
3.Concatenate string and number