Showing posts with label hello world in oracle. Show all posts
Showing posts with label hello world in oracle. Show all posts

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;
/