Write PL/SQL program to find the sum of digits of a number. – InterviewSolution

InterviewSolution

1.	Write PL/SQL program to find the sum of digits of a number.
Answer» DECLARE--Declare variables num, sum_of_digits and REMAINDER of datatype Integer num INTEGER; sum_of_digits INTEGER; remainder INTEGER; BEGINnum := 123456; sum_of_digits := 0;-- Find the sum of digits until original number DOESNT become null WHILE num <> 0 LOOP remainder := MOD(num, 10); sum_of_digits := sum_of_digits + remainder; num := TRUNC(num / 10); END LOOP; dbms_output.PUT_LINE('Sum of digits is '\|\| sum_of_digits); END; Input: 9874 Output: 28

Discussion

No Comment Found

Related InterviewSolutions

Write PL/SQL program to find the sum of digits of a number.
Write PL/SQL program to convert each digit of a given number into its corresponding word format.
Write a PL/SQL code to find whether a given string is palindrome or not.
Write PL/SQL code block to increment the employee’s salary by 1000 whose employee_id is 102 from the given table below.
Write a PL/SQL code to count the number of Sundays between the two inputted dates.
Write a PL/SQL procedure for selecting some records from the database using some parameters as filters.
Write a PL/SQL program using WHILE loop for calculating the average of the numbers entered by user. Stop the entry of numbers whenever the user enters the number 0.