**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:

`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 ` |

*chevron_right*

*filter_none*

**Output:**

Sum of the first and last digit is 9

## Recommended Posts:

- Difference between SQL and PLSQL
- PLSQL | LOG Function
- PLSQL | INSTR Function
- PLSQL | INSTRB Function
- PLSQL | LENGTH2 Function
- PLSQL | SOUNDEX Function
- PLSQL | ASCII Function
- PLSQL | CONCAT Function
- PLSQL | COMPOSE Function
- PLSQL | CHR Function
- PLSQL | ASCIISTR Function
- PLSQL | CONVERT Function
- PLSQL : || Operator
- PLSQL | DECOMPOSE Function
- PLSQL | DUMP Function
- PLSQL | INITCAP Function
- PLSQL | LENGTHC Function
- PLSQL | LENGTHB Function
- PLSQL | LENGTH4 Function
- PLSQL | LENGTH Function

If you like GeeksforGeeks and would like to contribute, you can also write an article using contribute.geeksforgeeks.org or mail your article to contribute@geeksforgeeks.org. See your article appearing on the GeeksforGeeks main page and help other Geeks.

Please Improve this article if you find anything incorrect by clicking on the "Improve Article" button below.