Wednesday, 24 February 2016

PL/SQL Scripting - 1 : Display "Hello, World!"


//* Display Hello World*//

Scripts:
--------

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***