HPL/SQL is included to Apache Hive since version 2.0
HPL/SQL is included to Apache Hive since version 2.0
DBMS_OUTPUT package allows you to send messages and can be helpful to debug programs
Example:
BEGIN DBMS_OUTPUT.PUT_LINE('Hello, world!'); END;
Compatibility: Oracle
PUT_LINE function writes a text string to the standard output (screen, by default). The function appends a line terminator.
Syntax:
DBMS_OUTPUT.PUT_LINE(text);
Parameters:
Parameter | Type | Description |
text | VARCHAR | Text string or expression |
Return Value:
No.
Example:
BEGIN DBMS_OUTPUT.PUT_LINE('Hello, world!'); END;