Sum of Digit of a Number.

00:53 0 Comments A+ a-

Write a PLSQL block to display sum of digit of a number.


Program:



DECLARE
N int:=56;
S int:=0;
R int:=0;
BEGIN
WHILE N !=0
LOOP
R:=MOD(N,10);
S:=S+R;
N:=TRUNC(N/10);
END LOOP;
DBMS_OUTPUT.PUT_LINE('SUM OF DIGITS OF GIVEN NUMBER IS '||S);
END;
/

Output:

SUM OF DIGITS OF GIVEN NUMBER IS 11