Oracle PLSQL Examples
Hello Friends , Below are Some PLSQL Sample Anonymous and named Block Program for your quick pick. Please ask if you have any question Related to PLSQL. *************Program to print the string on to the screen***************************** DECLARE v_name VARCHAR2(100):='&Name'; BEGIN DBMS_OUTPUT.PUT_LINE(V_NAME); END; / *************Program to print the string on to the screen***************************** *************Program to find out the the odd/Even Number****************************** DECLARE V_NUM NUMBER:=# BEGIN IF MOD(V_NUM,2)=0 THEN DBMS_OUTPUT.PUT_LINE('THE NUMBER ENTERED'||V_NUM||' is an EVEN Number'); ELSE DBMS_OUTPUT.PUT_LINE('THE NUMBER ENTERED'||V_NUM||' is an ODD Number'); END IF; END; / *************Program to find out the the odd/Even Number****************************** *************Program to find out the the greater/lesses Number************************ DECLARE V_NUM1 NUMBER:=&NUM...