PL/SQL Control Statement Exercises: Check whether a given character is letter or digit
PL/SQL Control Statement: Exercise-13 with Solution
Write a PL/SQL program to check whether a given character is letter or digit.
Sample Solution:
PL/SQL Code:
DECLARE
get_ctr CHAR(1) := '&input_a_character';
BEGIN
IF ( get_ctr >= 'A'
AND get_ctr <= 'Z' )
OR ( get_ctr >= 'a'
AND get_ctr <= 'z' ) THEN
dbms_output.Put_line ('The given character is a letter');
ELSE
dbms_output.Put_line ('The given character is not a letter');
IF get_ctr BETWEEN '0' AND '9' THEN
dbms_output.Put_line ('The given character is a number');
ELSE
dbms_output.Put_line ('The given character is not a number');
END IF;
END IF;
END;
/
Sample Output:
SQL> / Enter value for input_a_character: m old 2: get_ctr CHAR(1) := '&input_a_character'; new 2: get_ctr CHAR(1) := 'm'; The given character is a letter PL/SQL procedure successfully completed.
Sample Output:
SQL> / Enter value for input_a_character: 5 old 2: get_ctr CHAR(1) := '&input_a_character'; new 2: get_ctr CHAR(1) := '5'; The given character is not a letter The given character is a number PL/SQL procedure successfully completed.
Sample Output:
SQL> / Enter value for input_a_character: @ old 2: get_ctr CHAR(1) := '&input_a_character'; new 2: get_ctr CHAR(1) := '@'; The given character is not a letter The given character is not a number PL/SQL procedure successfully completed.
Flowchart:
Improve this sample solution and post your code through Disqus
Previous: Write a PL/SQL program to check whether a given number is positive, negative or zero.
Next: Write a PL/SQL program to convert a temperature in scale Fahrenheit to Celsius and vice versa.
What is the difficulty level of this exercise?
- New Content published on w3resource:
- HTML-CSS Practical: Exercises, Practice, Solution
- Java Regular Expression: Exercises, Practice, Solution
- Scala Programming Exercises, Practice, Solution
- Python Itertools exercises
- Python Numpy exercises
- Python GeoPy Package exercises
- Python Pandas exercises
- Python nltk exercises
- Python BeautifulSoup exercises
- Form Template
- Composer - PHP Package Manager
- PHPUnit - PHP Testing
- Laravel - PHP Framework
- Angular - JavaScript Framework
- Vue - JavaScript Framework
- Jest - JavaScript Testing Framework