Services
Technology Web App Development Mobile App Development Windows App Development Database Development UI/UX Development Cloud Development SEO Digital Marketing Guest Posting Content Writing Artificial Intelligence Data Science ERP Development CRM Development CMS Development LMS Development Business Listing Blockchain Technology Startup Promotion
Products
Data Converter Cleaner TUC - Unit Converter Import Export Survey Manager Tweet Controller
Developer
Article Blog Forum Interview Beginner News Startup Quiz
Users
Career
Apply Job Internship
Pricing
Login Sign Up Get a Quote

forum

home / developersection / forums / write a pl/sql code to find whether a given string is a palindrome or not.
Ask Question
Revati S Misra
Revati S Misra

Student

Skilled in SEO, content writing, and digital marketing. Completed several years of working in many organizations including multinational companies. I love to learn new things in life that keep me motivated.

Message

1 Answers

Krishnapriya Rajeev
Krishnapriya Rajeev 05 Apr 2023
Report Abuse

The following PL/SQL program checks whether the given string is a palindrome or not:

SET SERVEROUTPUT ON
DECLARE
     -- declare the string to be checked
     str VARCHAR2(10) := 'RACECAR';
     rev VARCHAR(10);
     c VARCHAR2(1);
   
begin
     -- for each character from last to first
     FOR i IN REVERSE 1..Length(str) LOOP
           -- extract each character from string
           c := Substr(str, i, 1);
          
           -- concatenate each character to reverse string
           rev := rev || c;
     END LOOP;
     
     -- check if both string and its reverse are equal
     IF rev = str
     THEN
           dbms_output.put_line(str || ' is a palindrome.');
     ELSE
           dbms_output.put_line(str || ' is not a palindrome.');
     END IF;
END;
/
-- OUTPUT : RACECAR is a palindrome.

We first declare the variables str (the string to be checked), rev (to store the reversed string), and c (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 str and rev are equal. If they are, the string is a palindrome.

MindStick Training