Oracle: Query to list first_name, last_name of employees with the pattern 'l_x' in their first name

Oracle Wildcard special Operator: Exercise-11 with Solution

Write a query to list first_name, last_name of employees with the pattern 'l_x' in their first name.

Sample table : employees

Sample Solution:

Oracle Code:

SELECT first_name, last_name
    FROM employees
    WHERE first_name LIKE '%l_x%' 
    ORDER BY first_name;

Output:

FIRST_NAME           LAST_NAME
-------------------- -------------------------
Alexander            Hunold
Alexander            Khoo
Alexis               Bull

Pictorial Presentation:

Improve this sample solution and post your code through Disqus.

Previous: Write a query to list the names (first and last), salary of those employees whose names having a character set ’ll’ together.