PL/SQL Practicals

/* pl/sql bloclk for +,-,*,/ of 2 nos.*/

Declare
A constant number(3):=10;
B constant number(3):=15;
c number(5);
Begin
C:=A+B;
Dbms_output.put_line('addition is' ||C);
C:=A-B;
Dbms_output.put_line('subtraction is' ||C);
C:=A*B;
Dbms_output.put_line('multiplication  is' ||C);
C:=A/B;
Dbms_output.put_line('division is' ||C);
End;
/

/*Pl/Sql block to find greatest of 3 nos.*/

Declare
A Constant Number(3):=15;
B Constant Number(3):=11;
C Constant Number(3):=12;
Begin
If(A>B) and (A>C) then
Dbms_output.put_line('Greatest No is'||A);
Else
if
(B>c) then
Dbms_output.put_line(Greater No is' ||B);
Else
Dbms_output.put_line(Greater No is' ||C);
End if;
End if;
End;
/


/* Pl/sql block to check wether no is even or odd */

Declare

S constant Number(3):=&A;

Begin

IF mod(S,2)=0 then
Dbms_output.put_line(No is Even'||s);
Else
Dbms_output.put_line(No is Odd'||s);
End if;
End;
/


/*pl?sql code for multiplication table*/

Declare
A Number:=&A;
I Number:=1;
S Number:=0;

Begin

S:=A*I;
I:=I+1;
Exit When I>11;
Dbms_output.putline(S);
End Loop;
End;
/