Assignment questions on Single row functions

1. Display all the employees whose job has string ‘MAN’
2. Display all the employees whose name has ‘L’ as third character.
3. Display the result in the following format, first character in lower case rest in uppercase.
4. Display all the employees which has at lest 2L’s in it.
5. Display the number of occurrence of substring in a string. Ex:Display the number of L’s in each name
6. Display all the employees whose name is palindrome
7. Replace third character with * in ename column.
8. Display ename with first 3 char in uppercase and remaining in lowercase.