PL/SQL block to check if string is palindrome

Q. Write a PL/SQL block to check whether string is palindrome or not.

Answer:

Palindrome string: It is a word or sequence of letters which can be read same as forward and backward.

For example:
MADAM

The following PL/SQL code will check weather the String is palindrome or not.

DECLARE str varchar2(50):='&string';
counter int:=length(str);
BEGIN dbms_output.put_line(counter);
LOOP exit WHEN counter=0;
exit WHEN not(substr(str,counter,1)=substr(str,((length(str)+1)-counter),1));
counter:=counter-1;
END LOOP;
IF counter=0 THEN dbms_output.put_line(str||'is palindrom');
ELSE dbms_output.put_line(str||'is not palindrom');
END IF;
END;
/


Output:

palindrome string
▲