Thursday, May 25, 2017

Hello World in Oracle PL/SQL

This will be my first time to write an PL/SQL code in Oracle using SQL Developer to display hello world message on the screen. Actually learning PL/SQL is easy and fun.  I hope you will learn from this one. Thank you.

My email address are the following jakerpomperada@gmail.com and jakerpomperada@yahoo.com.

My mobile number here in the Philippines is 09173084360.



Sample Program Output


Program Listing

Set serveroutput on;
DECLARE
message1 varchar2(50):= 'My First PL/SQL Script in Oracle';
message2 varchar2(50):= 'Hello, World Jake Pomperada';
BEGIN
dbms_output.put_line(chr(13)||chr(10) || message1 || chr(13)||chr(10) 
                     ||chr(13)||chr(10) || message2);
END;
/


No comments:

Post a Comment