﻿ PL/SQL Control Statement: Check whether a given character is letter or digit - w3resource

# 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

What is the difficulty level of this exercise?

﻿