阿姆斯壮数_阿姆斯壮编号的PL / SQL程序

男娘i 2022-12-07 13:54 161阅读 0赞

阿姆斯壮数

Here you will get pl/sql program for armstrong number.

在这里，您将获得用于阿姆斯特朗编号的pl / sql程序。

A number is said to be an armstrong number if sum of its digits raised to the power n is equal to number itself, where n is total digits in number.

如果一个数字的幂加到n等于数字本身，则该数字被称为阿姆斯特朗数。其中n是数字的总位数。

For example 407 is armstrong number as 43 \+ 03 \+ 73 = 64 + 0 + 343 = 407.

例如407是阿姆斯壮数，例如4 3 \+ 0 3 \+ 7 3 = 64 + 0 + 343 = 407。

## 阿姆斯壮编号的PL / SQL程序 **(**PL/SQL Program for Armstrong Number**)** ##

declare n number:=407; s number:=0; r number; len number; m number; begin m:=n; len:=length(to\_char(n)); while n>0 loop r:=mod(n,10); s:=s+power(r,len); n:=trunc(n/10); end loop; if m=s then dbms\_output.put\_line('armstrong number'); else dbms\_output.put\_line('not armstrong number'); end if; end; / declare n number:=407; s number:=0; r number; len number; m number; begin m:=n; len:=length(to\_char(n)); while n>0 loop r:=mod(n,10); s:=s+power(r,len); n:=trunc(n/10); end loop; if m=s then dbms\_output.put\_line('armstrong number'); else dbms\_output.put\_line('not armstrong number'); end if; end; /

<table> 
 <tbody> 
  <tr> 
   <td> 
    <div> 
     <div>
       1 
     </div> 
     <div>
       2 
     </div> 
     <div>
       3 
     </div> 
     <div>
       4 
     </div> 
     <div>
       5 
     </div> 
     <div>
       6 
     </div> 
     <div>
       7 
     </div> 
     <div>
       8 
     </div> 
     <div>
       9 
     </div> 
     <div>
       10 
     </div> 
     <div>
       11 
     </div> 
     <div>
       12 
     </div> 
     <div>
       13 
     </div> 
     <div>
       14 
     </div> 
     <div>
       15 
     </div> 
     <div>
       16 
     </div> 
     <div>
       17 
     </div> 
     <div>
       18 
     </div> 
     <div>
       19 
     </div> 
     <div>
       20 
     </div> 
     <div>
       21 
     </div> 
     <div>
       22 
     </div> 
     <div>
       23 
     </div> 
     <div>
       24 
     </div> 
     <div>
       25 
     </div> 
     <div>
       26 
     </div> 
     <div>
       27 
     </div> 
     <div>
       28 
     </div> 
    </div> </td> 
   <td> 
    <div> 
     <div>
       declare 
     </div> 
     <div>
       &nbsp;&nbsp;&nbsp;&nbsp;n number:=407; 
     </div> 
     <div>
       &nbsp;&nbsp;&nbsp;&nbsp;s number:=0; 
     </div> 
     <div>
       &nbsp;&nbsp;&nbsp;&nbsp;r number; 
     </div> 
     <div>
       &nbsp;&nbsp;&nbsp;&nbsp;len number; 
     </div> 
     <div>
       &nbsp;&nbsp;&nbsp;&nbsp;m number; 
     </div> 
     <div>
       begin 
     </div> 
     <div>
       &nbsp;&nbsp;&nbsp;&nbsp;m:=n; 
     </div> 
     <div>
       &nbsp;&nbsp;&nbsp;&nbsp;len:=length(to_char(n)); 
     </div> 
     <div>
       &nbsp;&nbsp;&nbsp;&nbsp;while n&gt;0 
     </div> 
     <div>
       &nbsp;&nbsp;&nbsp;&nbsp;loop 
     </div> 
     <div>
       &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;r:=mod(n,10); 
     </div> 
     <div>
       &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;s:=s+power(r,len); 
     </div> 
     <div>
       &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;n:=trunc(n/10); 
     </div> 
     <div>
       &nbsp;&nbsp;&nbsp;&nbsp;end loop; 
     </div> 
     <div>
       &nbsp;&nbsp;&nbsp;&nbsp;if m=s 
     </div> 
     <div>
       &nbsp;&nbsp;&nbsp;&nbsp;then 
     </div> 
     <div>
       &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;dbms_output.put_line('armstrong number'); 
     </div> 
     <div>
       &nbsp;&nbsp;&nbsp;&nbsp;else 
     </div> 
     <div>
       &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;dbms_output.put_line('not armstrong number'); 
     </div> 
     <div>
       &nbsp;&nbsp;&nbsp;&nbsp;end if; 
     </div> 
     <div>
       end; 
     </div> 
     <div>
       / 
     </div> 
    </div></td> 
  </tr> 
 </tbody> 
</table>

<table> 
 <tbody> 
  <tr> 
   <td> 
    <div> 
     <div>
       1 
     </div> 
     <div>
       2 
     </div> 
     <div>
       3 
     </div> 
     <div>
       4 
     </div> 
     <div>
       5 
     </div> 
     <div>
       6 
     </div> 
     <div>
       7 
     </div> 
     <div>
       8 
     </div> 
     <div>
       9 
     </div> 
     <div>
       10 
     </div> 
     <div>
       11 
     </div> 
     <div>
       12 
     </div> 
     <div>
       13 
     </div> 
     <div>
       14 
     </div> 
     <div>
       15 
     </div> 
     <div>
       16 
     </div> 
     <div>
       17 
     </div> 
     <div>
       18 
     </div> 
     <div>
       19 
     </div> 
     <div>
       20 
     </div> 
     <div>
       21 
     </div> 
     <div>
       22 
     </div> 
     <div>
       23 
     </div> 
     <div>
       24 
     </div> 
     <div>
       25 
     </div> 
     <div>
       26 
     </div> 
     <div>
       27 
     </div> 
     <div>
       28 
     </div> 
    </div> </td> 
   <td> 
    <div> 
     <div>
       declare 
     </div> 
     <div>
       &nbsp;&nbsp;&nbsp;&nbsp; n number : = 407 ; 
     </div> 
     <div>
       &nbsp;&nbsp;&nbsp;&nbsp; s number : = 0 ; 
     </div> 
     <div>
       &nbsp;&nbsp;&nbsp;&nbsp; r number ; 
     </div> 
     <div>
       &nbsp;&nbsp;&nbsp;&nbsp; len number ; 
     </div> 
     <div>
       &nbsp;&nbsp;&nbsp;&nbsp; m number ; 
     </div> 
     <div>
       begin 
     </div> 
     <div>
       &nbsp;&nbsp;&nbsp;&nbsp; m : = n ; 
     </div> 
     <div>
       &nbsp;&nbsp;&nbsp;&nbsp; len : = length ( to_char ( n ) ) ; 
     </div> 
     <div>
       &nbsp;&nbsp;&nbsp;&nbsp; while n &gt; 0 
     </div> 
     <div>
       &nbsp;&nbsp;&nbsp;&nbsp; loop 
     </div> 
     <div>
       &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; r : = mod ( n , 10 ) ; 
     </div> 
     <div>
       &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; s : = s + power ( r , len ) ; 
     </div> 
     <div>
       &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; n : = trunc ( n / 10 ) ; 
     </div> 
     <div>
       &nbsp;&nbsp;&nbsp;&nbsp; end loop ; 
     </div> 
     <div>
       &nbsp;&nbsp;&nbsp;&nbsp; if m = s 
     </div> 
     <div>
       &nbsp;&nbsp;&nbsp;&nbsp; then 
     </div> 
     <div>
       &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; dbms_output . put_line ( 'armstrong number' ) ; 
     </div> 
     <div>
       &nbsp;&nbsp;&nbsp;&nbsp; else 
     </div> 
     <div>
       &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; dbms_output . put_line ( 'not armstrong number' ) ; 
     </div> 
     <div>
       &nbsp;&nbsp;&nbsp;&nbsp; end if ; 
     </div> 
     <div>
       end ; 
     </div> 
     <div>
       / 
     </div> 
    </div></td> 
  </tr> 
 </tbody> 
</table>

**Output**

**输出量**

*armstrong number*

*阿姆斯特朗号*

> 翻译自: [https://www.thecrazyprogrammer.com/2017/08/plsql-program-armstrong-number.html][https_www.thecrazyprogrammer.com_2017_08_plsql-program-armstrong-number.html]

阿姆斯壮数

[https_www.thecrazyprogrammer.com_2017_08_plsql-program-armstrong-number.html]: https://www.thecrazyprogrammer.com/2017/08/plsql-program-armstrong-number.html