Write a PL/SQL code to find whether a given string is palindrome or no – InterviewSolution

InterviewSolution

1.	Write a PL/SQL code to find whether a given string is palindrome or not.
Answer» DECLARE-- Declared variables string, letter, reverse_string where string is the original string. string VARCHAR2(10) := 'abccba'; letter VARCHAR2(20); reverse_string VARCHAR2(10); BEGINFOR i IN REVERSE 1..LENGTH(string) LOOP letter := SUBSTR(string, i, 1); -- concatenate letter to reverse_string variable reverse_string := reverse_string \|\|''\|\|letter; END LOOP;IF reverse_string = string THEN dbms_output.Put_line(reverse_string\|\|''\|\|' is palindrome'); ELSE dbms_output.Put_line(reverse_string \|\|'' \|\|' is not palindrome'); END IF; END;

Discussion

No Comment Found

Related InterviewSolutions

Write PL/SQL program to find the sum of digits of a number.
Write PL/SQL program to convert each digit of a given number into its corresponding word format.
Write a PL/SQL code to find whether a given string is palindrome or not.
Write PL/SQL code block to increment the employee’s salary by 1000 whose employee_id is 102 from the given table below.
Write a PL/SQL code to count the number of Sundays between the two inputted dates.
Write a PL/SQL procedure for selecting some records from the database using some parameters as filters.
Write a PL/SQL program using WHILE loop for calculating the average of the numbers entered by user. Stop the entry of numbers whenever the user enters the number 0.