v_webdeveloper's blog

Oracle 9i PL/SQL Language Fundamentals

My First PL/SQL program Smile

 

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;

 


Custom Search

Syndicate content