v_webdeveloper's blog
Oracle 9i PL/SQL Language Fundamentals
My First PL/SQL program 
DECLARATION FOR DATE USING PLSQL
SET SERVEROUTPUT ON
DECLARE
MyName VARCHAR2(10);
MyWeight NUMBER;
today DATE DEFAULT SYSDATE;
BEGIN
MyName :='Khairi';
MyWeight :=60;
DBMS_OUTPUT.PUT_LINE('Hello from Oracle.');
DBMS_OUTPUT.PUT_LINE(MyName);
DBMS_OUTPUT.PUT_LINE('Welcome to Oracle,' || MyName);
DBMS_OUTPUT.PUT_LINE('my name is ' || MyName || 'and my weight is ' || MyWeight);
DBMS_OUTPUT.PUT_LINE('Today is ' || today);
END;
DECLARATION FOR CHAR AND NUMBER USING PLSQL
SET SERVEROUTPUT ON
DECLARE
MyName VARCHAR2(10);
MyWeight NUMBER;
BEGIN
MyName :='Khairi';
MyWeight :=60;
DBMS_OUTPUT.PUT_LINE('Hello from Oracle.');
DBMS_OUTPUT.PUT_LINE(MyName);
DBMS_OUTPUT.PUT_LINE('Welcome to Oracle,' || MyName);
DBMS_OUTPUT.PUT_LINE('my name is ' || MyName || 'and my weight is ' || MyWeight);
END;
- Add new comment
- Read more
- 892 reads

Recent comments
15 hours 35 min ago
1 day 17 hours ago
2 days 21 hours ago
3 days 35 min ago
3 days 13 hours ago
4 days 18 hours ago
2 weeks 2 days ago
2 weeks 3 days ago
2 weeks 3 days ago
2 weeks 3 days ago