Program to perform Simple Switch CASE in PL/SQL In this Switch case is same as in C language. Only the differenc...
Read More
Showing posts with label PL/SQL. Show all posts
Showing posts with label PL/SQL. Show all posts
Program to perform EXIT statement in PL/SQL
Program to perform EXIT statement: DECLARE A int; BEGIN A:=10; LOOP DBMS_OUTPUT.PUT_LINE(A); A:=A+10; IF A>10...
Read More
Program to perform Searched Switch CASE in PL/SQL
Program to perform Searched Switch CASE in PL/SQL In this Switch case is same as in C language. Only t...
Read More
Program to perform GOTO statement in PL/SQL
Program to perform GOTO statement in PL/SQL In PL/SQL GOTO statement is same as in C language.It move the c...
Read More
PL/SQL NOTES
PL/SQL NOTES
Read More
STATE THE OUTPUT FOR PL/SQL CODE
--1>STATE THE OUTPUT DECLARE I NUMBER:=0; BEGIN LOOP DBMS_OUTPUT.PUT_LINE('I='||I); I:=I+1; EX...
Read More
WRITE A PL/SQL PROGRAM FOR ACCEPTING THREE NUMBER AND DISPLAY LARGEST ONE
ACCEPT THREE NUMBER AND DISPLAY LARGEST ONE DECLARE A INT; B INT; C INT; LARGE INT; BEGIN A:=&A; B:=&B; C:=&C; IF A...
Read More
WRITE A PL/SQL PROGRAM FOR EVEN NUMBER BETWEEN 1 TO 100
EVEN NUMBER BETWEEN 1 TO 100 DECLARE NUM INT; BEGIN DBMS_OUTPUT.PUT_LINE('EVEN NUMBERS: '); FOR NUM IN 1..100 LOOP IF MOD(N...
Read More
WRITE A PL/SQL PROGRAM FACTORIAL OF GIVEN NUMBER BY USING WHILE LOOP
FACTORIAL OF GIVEN NUMBER BY USING WHILE LOOP DECLARE NUM NUMBER(3); FACT NUMBER(10); BEGIN NUM:=# FACT:=1; DBMS_OUTPUT.PUT...
Read More
Subscribe to:
Posts (Atom)
