Interview Questions on Functions

You can solve the below question using like operator or  by using functions

1. Display all the employees whose name does not start with ‘S’
2. Display all the employees whose name is start and end with ‘A’
3. Display all the clerks and analyst whose name is ‘TH’
4. Display all the employees whose name last but one character is ‘R’
5. List all the employees name is having a character ‘IN’
6. List all the employees whose job is having a string ‘ER’
7. Display all the employees joined on DEC
8. Display all the employees whose department number start with 3
9. Display all the employees whose name is having exactly 5 character and their empno end with 88
10. List all the employees whose name has sting ‘DAMS’