Prerequisite – PL/SQL introduction
In PL/SQL code groups of commands are arranged within a block. A block group related declarations or statements. In declare part, we declare variables and between begin and end part, we perform the operations.
Given a string and the task is to find whether it is Palindrome or not.
Input: str = geeksskeeg Output: geeksskeeg is palindrome Input: str = geeks Output: geeks is not palindrome
Approach is to take the string, reverse it and check whether the reversed string is equal to the original string or not. If it is equal, then it will be palindrome otherwise not.
Below is the required implementation:
abccba is palindrome
- Comparisons between SQL vs PLSQL
- Check if a number is Palindrome in PL/SQL
- SQL | CHECK Constraint
- Check whether a given number is even or odd in PL/SQL
- Check Armstrong Number in PL/SQL
- Check if Table, View, Trigger, etc present in Oracle
- Reverse a string in PL/SQL
- SQL | String functions
- No. of vowels and consonants in a given string in PL/SQL
- Count no. of characters and words in a string in PL/SQL
- Check if a given year is leap year in PL/SQL
- SELECT INTO statement in SQL
- Pivot and Unpivot in SQL
- Common error in Group By
If you like GeeksforGeeks and would like to contribute, you can also write an article using contribute.geeksforgeeks.org or mail your article to email@example.com. See your article appearing on the GeeksforGeeks main page and help other Geeks.
Please Improve this article if you find anything incorrect by clicking on the "Improve Article" button below.