This tutorial demonstrates the Oracle PL/SQL interview question of writing a program for finding whether a number or string is a palindrome number or string.
Here I have written an Oracle PL/SQL procedure which takes input an integer or a string which is to be identified for palindrome number or string.
CREATE OR REPLACE PROCEDURE P_CHECK_PALINDROME (P_STR VARCHAR2)
IS
P_REV_STR VARCHAR2(30);
BEGIN
FOR I IN REVERSE 1 .. LENGTH(P_STR)
LOOP
P_REV_STR := P_REV_STR || SUBSTR(P_STR,I,1);
END LOOP;
DBMS_OUTPUT.PUT_LINE('P_REV_STR '||P_REV_STR );
IF P_STR = P_REV_STR THEN
DBMS_OUTPUT.PUT_LINE('PALINDROME' );
ELSE
DBMS_OUTPUT.PUT_LINE('NOT A PALINDROME' );
END IF;
END;
/
The procedure can be executed as follows:
SET SERVEROUTPUT ON;
EXEC P_CHECK_PALINDROME ('PLSQL');