Enabling printing.
authorOleksandr Gavenko <gavenkoa@gmail.com>
Sun, 05 Mar 2017 23:40:09 +0200
changeset 2114 9295a7068b80
parent 2113 6c7691230622
child 2115 0263a79eeb3b
Enabling printing.
oracle.rst
--- a/oracle.rst	Sun Mar 05 21:20:37 2017 +0200
+++ b/oracle.rst	Sun Mar 05 23:40:09 2017 +0200
@@ -31,7 +31,6 @@
 ===================
 ::
 
-  set serveroutput on;
   set autotrace on statistics;
   set timing on;
 
@@ -50,6 +49,14 @@
   end;
   /
 
+Enabling printing::
+
+  set serveroutput on;
+  exec DBMS_OUTPUT.PUT_LINE('Hello');
+  exec DBMS_OUTPUT.DISABLE();
+  exec DBMS_OUTPUT.PUT_LINE('Silence');
+  exec DBMS_OUTPUT.ENABLE();
+
 Database info.
 ==============