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