DBMS_OUTPUT.PUT_LINE in PLSQL

In Oracle PL/SQL, the method to print output is using the DBMS_OUTPUT.PUT_LINE procedure. This procedure writes text to the console or output buffer, which can be viewed after execution if DBMS_OUTPUT is enabled. Here’s how you use it:

1. First, enable output in your SQL environment (like SQL*Plus or Oracle SQL Developer):

SET SERVEROUTPUT ON;

1. Use DBMS_OUTPUT.PUT_LINE to print output:

BEGIN
DBMS_OUTPUT.PUT_LINE('Hello, World!');
END;
/

This will display:

Hello, World!

Make sure that SERVEROUTPUT is enabled; otherwise, you won't see the output in your console.

The above is the detailed content of DBMS_OUTPUT.PUT_LINE in PLSQL. For more information, please follow other related articles on the PHP Chinese website!