Showing posts with label PL/SQL Scripting. Show all posts
Showing posts with label PL/SQL Scripting. Show all posts

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

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