Skip to content
Related Articles

Related Articles

Improve Article

Check if a number is Palindrome in PL/SQL

  • Difficulty Level : Easy
  • Last Updated : 16 May, 2018
Geek Week

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
My Personal Notes arrow_drop_up
Recommended Articles
Page :