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.