w3resource

Oracle Wildcard special Operators - Exercises with Solution

Oracle Wildcard special Operators [11 exercises with solution]

1. Write a query to list the names (first and last) of those employees whose name starts with A.

Click me to see the solution

2. Write a query to list the names (first and last) of those employees whose last name ends with a.

Click me to see the solution

3. Write a query to list the names (first and last) of those employees whose name have second alphabet 's' in their names.

Click me to see the solution

4. Write a query to list the names (first and last) of those employees whose first name has only five characters.

Click me to see the solution

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

Click me to see the solution

6. 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'.

Click me to see the solution

7. Write a query to list the names (first and last) of the employees whose first name has only five characters and starting with 'S' and ending with 'n'.

Click me to see the solution

8. Write a query to list the names (first and last), hire date of those employees who joined in the month of which second character is 'u'.

Click me to see the solution

9. Write a query to list the names (first and last), salary of those employees whose salary is four digit number ending with Zero.

Click me to see the solution

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

Click me to see the solution

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

Click me to see the solution

More to Come !



Follow us on Facebook and Twitter for latest update.