Check if a number is Palindrome in PL/SQL

Check if a number is Palindrome in PL/SQL

Last Updated : 13 Mar, 2023

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:

SQL

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

Check if a number is Palindrome in PL/SQL

V

vt_m

Improve

Article Tags :

Practice Tags :

Similar Reads

Check if a number is Palindrome

Given an integer n, find whether the number is Palindrome or not. A number is a Palindrome if it remains the same when its digits are reversed.Examples:Input: n = 12321Output: YesExplanation: 12321 is a Palindrome number because after reversing its digits, the number becomes 12321 which is the same

Check if a Number is Palindromic Prime

A palindromic prime (sometimes called a palprime) is a prime number that is also a palindromic number. Given a number n, print all palindromic primes smaller than or equal to n. For example, If n is 10, the output should be â€œ2, 3, 5, 7'. And if n is 20, the output should be â€œ2, 3, 5, 7, 11'.Idea is

Check if number is palindrome or not in base B

Given an integer N, the task is to check if N_B (N in base B) is palindrome or not. Examples: Input: N = 5, B = 2 Output: Yes Explanation: (5)10 = (101)2 which is palindrome. Therefore, the required output is Yes.Input: N = 4, B = 2 Output: No Approach: The problem can be solved by checking if the d

Bash program to check if the Number is a Palindrome

Given a number num, find whether the given number is palindrome or not using Bash Scripting. Examples: Input : 666 Output : Number is palindrome Input : 45667 Output : Number is NOT palindrome Approach To find the given number is palindrome just check if the number is same from beginning and the end

Check if number is palindrome or not in Octal

Given a number which may be in octal or in decimal. If the number is not octal then convert it into octal then check if it is palindrome or not. If it is palindrome then print 1 otherwise print 0. If the number is already in octal then check if the number is palindrome or not.Examples : Input :n = 1

Check whether a string is palindrome or not 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 string and the task is to find whether it is Pa

Check if a number is Full Prime

A full prime number is one in which the number itself is prime and all its digits are also prime. Given a number n, check if it is Full Prime or not.Examples : Input : 53 Output : Yes Explanation: Number 53 is prime and its digits are also prime. Input : 41 Output : No Explanation: Number 41 is prim

Check whether the given floating point number is a palindrome

Given a floating-point number N, the task is to check whether it is palindrome or not. Input: N = 123.321 Output: YesInput: N = 122.1 Output: No Approach: First, convert the given floating-point number into a character array.Initialize the low to first index and high to the last index.While low <

Check if binary representation of a number is palindrome

Given an integer x, determine whether its binary representation is a palindrome. Return true if it is a palindrome; otherwise, return false.Input: x = 9Output: trueExplanation: The binary representation of 9 is 1001, which is a palindrome.Input: x = 10Output: falseExplanation: The binary representat

Check whether a given number is even or odd 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. Examples: Input: 2 Output: even Input: 5 Output: odd Th