Differences

This shows you the differences between two versions of the page.

@@ Line 1: / Line 1: @@
+====== DBMS_OUTPUT Package - PL/HQL Reference ======
+DBMS_OUTPUT package allows you to send messages and can be helpful to debug programs
+**Example:**
+<code language="sql">
+BEGIN
+  DBMS_OUTPUT.PUT_LINE('Hello, world!');
+END;
+</code>
+**Compatibility**: Oracle
+===== PUT_LINE Function =====
+PUT_LINE function writes a text string to the standard output (screen, by default). The function appends a line terminator.
+**Syntax:**
+<code>
+DBMS_OUTPUT.PUT_LINE(text);
+</code>
+**Parameters:**
+| **Parameter** | **Type** | **Description** |
+| text | VARCHAR | Text string or expression |
+**Return Value:**
+No.
+**Example:**
+<code language="sql">
+BEGIN
+  DBMS_OUTPUT.PUT_LINE('Hello, world!');
+END;
+</code>

HPL/SQL - Procedural SQL on Hadoop, NoSQL and RDBMS