PL/SQL Scripting - 1

//* Display Hello World*//

PL/SQL Scripting - 1

DECLARE
 message VARCHAR2(100);
BEGIN
 meassage := 'Hello, World!';
 DBMS_OUTPUT.PUT_LINE(message);
END;
/

Output:

--------

SQL> @helloworld.sql

PL/SQL procedure successfully completed.

//* It is not showing "Hello, World!" on the screen. *//

Second Try:

-------------

Set your server output on and execute the script.

Example is given below -

SQL> set serveroutput on

SQL> @helloworld.sql

Hello, World!

PL/SQL procedure successfully completed.

***SUVARAMB***