It is a sample pl/sql program to take input a number from user and it checks accepted number is Armstrong or not.
Output: -
Enter value for pnum: 153
old 7: pnum:=&pnum;
new 7: pnum:=153;
153 is armstrong.
Aim - PL/SQL program to check whether number is Armstrong or not.
Program:-declare
pnum number(5);
tot number(5);
lp number(3);
tmp number(5);
begin
pnum:=&pnum;
tmp:=pnum;
tot:=0;
while tmp>0
loop
lp:=tmp mod 10;
tot:= tot + (lp*lp*lp);
tmp:=floor(tmp/10);
end loop;
if(tot like pnum) then
dbms_output.put_line(pnum||' is armstrong.');
else
dbms_output.put_line(pnum||' is not armstrong.');
end if;
end;
Output: -
Enter value for pnum: 153
old 7: pnum:=&pnum;
new 7: pnum:=153;
153 is armstrong.

Dont SPAM