w3resource

Oracle: List the names of those employees whose first name has only five characters and starts with 'A'

Oracle Wildcard special Operator: Exercise-5 with Solution

Write a query to list the names (first and last) of those employees whose first name has only five characters and starts with ‘A’.

Sample table : employees


Sample Solution:

Oracle Code:

SELECT  first_name, last_name  
FROM employees 
WHERE first_name like ’A%’ and length(first_name) = 5;

Output:

FIRST_NAME           LAST_NAME
-------------------- -------------------------
Allan                McEwen
Alana                Walsh

Pictorial Presentation:

Pictorial: List the names of those employees whose first name has only five characters and starts with 'A'

Improve this sample solution and post your code through Disqus.

Previous: Write a query to list the names (first and last) of those employees whose first name has only five characters.
Next: Write a query to list the names (first and last) of those employees whose first name has only five characters and last name have third alphabet ends with 's'.

What is the difficulty level of this exercise?



Follow us on Facebook and Twitter for latest update.