Write a PL/SQL code to find whether a given string is a palindrome or not.

Question

Krishnapriya Rajeev · Answer

The following PL/SQL program checks whether the given string is a palindrome or not:
SET SERVEROUTPUT ON
DECLARE
 and and and  -- declare the string to be checked
 and and and  str VARCHAR2(10) := 'RACECAR';
 and and and  rev VARCHAR(10);
 and and and  c VARCHAR2(1);
begin
 and and and  -- for each character from last to first
 and and and  FOR i IN REVERSE 1..Length(str) LOOP
 and and and and and and and and and  -- extract each character from string
 and and and and and and and and and  c := Substr(str, i, 1);
 and and and  and and and and  
 and and and and and and and and and  -- concatenate each character to reverse string
 and and and and and and and and and  rev := rev || c;
 and and and  END LOOP;
 and and and  
 and and and  -- check if both string and its reverse are equal
 and and and  IF rev = str
 and and and  THEN
 and and and and and and and and and  dbms_output.put_line(str || ' is a palindrome.');
 and and and  ELSE
 and and and and and and and and and  dbms_output.put_line(str || ' is not a palindrome.');
 and and and  END IF;
END;
/
-- OUTPUT : RACECAR is a palindrome.
We first declare the variables strand (the string to be checked), rev 
(to store the reversed string), and cand (to extract each character). Using a FOR loop that iterates from the length of the string to 1, we extract each character from the string and concatenate it to the reversed string. Finally, we check if
strand and rev are equal. If they are, the string is a palindrome.

forum

Write a PL/SQL code to find whether a given string is a palindrome or not.

Revati S Misra

Can you answer this question?

1 Answers

Liked By