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:
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?
- 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