The data that you manipulate in PL/SQL programs, you definitely would want to see/view/display that data on your screens. This can be achieved by using PUT and PUT_LINE procedures of DBMS-OUTPUT package. This can be used as per following syntax:
DBMS_OUTPUT.PUT/PUT_LINE (<string>);
For example, following statement
DBMS_OUTPUT.AJT_UNE ('Welcome to
PL/SQL:),
will print a string Welcome to PL/SQL on the console output.
But before one uses DBMS_OUTPUT package, make sure to type
following command:
SET SERVEROUTPUT ON
at SQL> prompt.
Some most useful procedures of DBMS_OUTPUT package al e
being listed below: