This shows you the differences between two versions of the page.
dbms-output [2015/09/23 20:27] |
dbms-output [2015/09/23 20:27] (current) |
||
---|---|---|---|
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> |