Finding sum of first n natural numbers in PL/SQL

Sum of the first and last digit of a number in PL/SQL

Last Updated : 04 Jul, 2018

Prerequisite - PL/SQL introduction In PL/SQL code groups of commands are arranged within a block. A block group related declarations or statements. In declare part, we declare variables and between begin and end part, we perform the operations. Given a number n, the task is to find the sum of its first and last digit. Examples:

Input: 14598.
Output: Sum of the first and last digit is 9.

Input: 987456.
Output: Sum of the first and last digit is 15.

Approach is to use the substr() function and store the first and last digit and then print their sum. Below is the required implementation:

SQL

DECLARE 
    -- declare variables are A, B,  C and S
    -- these are same datatype integer
    a INTEGER := 14598; 
    b INTEGER := 0; 
    C INTEGER := 0; 
    s INTEGER; 
BEGIN 
    IF a > 9 THEN 
      c := Substr(a, 1, 1); 

      b := Substr(a, Length(a), 1); 

      s := b + c; 
    ELSE 
      s := a; 
    END IF; 

    dbms_output.Put_line('Sum of the first and last digit is ' 
                         ||s); 
END; 
-- Program End

Output:

Sum of the first and last digit is 9

Finding sum of first n natural numbers in PL/SQL

S

Shashank12

Improve

Article Tags :

Practice Tags :

Misc

Similar Reads

Sum of digits of a number in PL/ SQL

Prerequisite - PL/SQL introduction In PL/SQL code groups of commands are arranged within a block. A block group related declarations or statements. In declare part, we declare variables and between begin and end part, we perform the operations. Given a number and task is to find the sum of digits of

Finding sum of first n natural numbers in PL/SQL

Prerequisite - PL/SQL introduction In PL/SQL code groups of commands are arranged within a block. A block group related declarations or statements. In declare part, we declare variables and between begin and end part, we perform the operations. Given a positive integer n and the task is to find the

Sum of digits equal to a given number in PL/SQL

Prerequisite - PL/SQL introduction In PL/SQL code groups of commands are arranged within a block. A block group related declarations or statements. In declare part, we declare variables and between begin and end part, we perform the operations. Given a number and range and the task is to display all

Find first and last digits of a number

Given a number to find the first and last digit of a number.Examples: Input : 12345 Output : First digit: 1 last digit : 5 Input : 98562 Output : First digit: 9 last digit : 2 Recommended PracticeCorner Digits SumTry It! To find last digit of a number, we use modulo operator %. When modulo divided b

Sum and average of three numbers in PL/SQL

Prerequisite - PL/SQL introduction In PL/SQL code groups of commands are arranged within a block. A block group related declarations or statements. In declare part, we declare variables and between begin and end part, we perform the operations. Given three numbers and the task is to find out the sum

Sum of digits of a given number to a given power

Given a number, we need to find the sum of all the digits of a number which we get after raising the number to a specified power.Examples: Input: number = 5, power = 4 Output: 13 Explanation: Raising 5 to the power 4 we get 625. Now adding all the digits = 6 + 2 + 5 Input: number = 9, power = 5 Outp

Find the factorial of a number in pl/sql

Given a number, your task to print the factorial of that number using pl/sql. Examples: Input : 5 Output : 120 Explanation: 5! = 5 * 4 * 3 * 2 * 1 = 120 Input : 4 Output : 24 Basic structure of pl/sql block declare -- declare all the variables begin -- for start block -- make a program here end -- f

PHP | Sum of digits of a number

This is a simple PHP program where we need to calculate the sum of all digits of a number. Examples: Input : 711 Output : 9 Input : 14785 Output : 25 In this program, we will try to accept a number in the form of a string and then iterate through the length of the string. While iterating we will ext

First N terms whose sum of digits is a multiple of 10

Given an integer N, the task is to print the first N terms whose sum of digits is a multiple of 10. First few terms of the series are 19, 28, 37, 46, 55, ...Examples: Input: N = 5 Output: 19 28 37 46 55Input: N = 10 Output: 19 28 37 46 55 64 73 82 91 109 Recommended: Please try your approach on {IDE

Print all odd numbers and their sum from 1 to n in PL/SQL

Prerequisite - PL/SQL introduction In PL/SQL code groups of commands are arranged within a block. A block group related declarations or statements. In declare part, we declare variables and between begin and end part, we perform the operations. Given a number N, the task is to display all the odd nu