Friday, 28 March 2014

PL/SQL PROGRAM TO FIND BIG NUMBER

declare
a number:=&a;
b number:=&b;
c number:=&c;
begin
if( ( a > b) and ( a > c )) then
dbms_output.put_line('a is big');
elsif(( b > a ) and ( b > c )) then
dbms_output.put_line('b is big');
elsif(( c > a ) and ( c > b )) then
dbms_output.put_line('c is big');
end if;
end;




OUTPUT:


Enter value for a: 12
old   2: a number:=&a;
new   2: a number:=12;
Enter value for b: 50
old   3: b number:=&b;
new   3: b number:=50;
Enter value for c: 90
old   4: c number:=&c;
new   4: c number:=90;
c is big