In this PL/SQL program, you will take three numbers from users and find the largest number among the three numbers.
write a pl/sql program to accept three numbers and display the largest number
declare
x number;
y number;
z number;
g number;
begin
x:=&x;
y:=&y;
z:=&z;
if (x>y) then
g:=x;
else
g:=y;
end if;
if(z>g) then
g:=z;
end if;
dbms_output.put_line('max number are '||g);
end;
/
Enter value for x: 10 old 7: x:=&x; new 7: x:=10; Enter value for y: 12 old 8: y:=&y; new 8: y:=12; Enter value for z: 15 old 9: z:=&z; new 9: z:=15; max number are 15