Check if a number is Palindrome in PL/SQL

Given an integer, write a function that returns true if the given number is palindrome, else false. For example, 12321 is palindrome, but 1451 is not palindrome. Let the given number be num. A simple method for this problem is to first reverse digits of num, then compare the reverse of num with num. If both are same, then return true, else false. Examples:
```Input : 12221
Output : true

Input : 12345
Output : false
```
Below is the required implementation:
 `declare`` ` `-- declare variable n, m, temp  ``-- and temp of datatype number ``    ``n number; ``    ``m number; ``    ``temp` `number:=0; ``    ``rem number; ``  ` `begin``    ``n:=5432112345; ``    ``m:=n; ``     ` `    ``-- while loop with condition till n>0 ``    ``while n>0 ``    ``loop ``        ``rem:=mod(n,10); ``        ``temp``:=(``temp``*10)+rem; ``        ``n:=trunc(n/10); ``    ``end` `loop; ``-- end of while loop here ``     ` `    ``if m = ``temp``    ``then``        ``dbms_output.put_line(``'true'``); ``    ``else``        ``dbms_output.put_line(``'false'``); ``    ``end` `if; ``end``; ``/ `` ` `-- Program End `

Output:
`true`

Previous
Next