1. List employees whose name having 4 characters
2. List employees whose job is having 7 characters
3. Find out how many times letter 'S' occurs in 'solutions'
4. List the employees whose job is having last 3 characters as 'man'
5. List employees whose job is having first 3 characters as 'man'.
6. Display all the names whose name is having exactly 1 'L'
7. Display dept names which are having letter 'O'
8. Display the output as shown below, Scott working as a clerk earns 3000 in dept 20
9. Calculate number of L in string 'HELLLLL'
10. Display all the employees whose job has a string 'MAN'
11. Display all the employees whose job starts with string 'MAN'
12. Display all the employees whose job ends with string 'MAN'
13. Display first 3 characters of ename in lower case and rest everything in upper case. If ename is 'CODINGMOMENTS' then display this as ‘codINGMOMENTS’
14. Display the result from emp table as below. SMITH is a CLERK and gets salary 2000 Here SMITH is ename column, CLERK is JOB and 2000 is SAL column and rest everything is literal strings.
15.list the employees hired on a Wednesday
16.list the employees hired on a leap year
17.list the employees hired on a Sunday in the month of may
18. WAQTD HIREDATES IN US FORMAT
19. DISPLAY FIRST HALF OF NAME IN LOWER CASE AND REST IN REVERSE.
20. WAQTD LAST 3 CHAR OF EMP WHO ARE WORKING AS MANAGER
21. WAQTD NAME OF THE EMP WHOSE NAME ENDS WITH ‘S’
22. WAQTD NAME OF THE EMP WHOSE NAME ENDS WITH S OR N
23. WAQTD NAME OF EMP IF HIS NAME START WITH VOWEL
24. WAQTD 1ST HALF OF EMP NAME
25. WAQTD 2ND HALF OF EMP NAME
26. WAQTD NAME OF EMP WITHOUT 1ST AND LAST CHAR
27. WAQTD NAME OF THE EMP WITH CHAR ‘A’ IN NAME
28. WAQTD NAME OF THE EMP AND HIS DNAME IF CHAR ‘O’ IS PRESENT IN EMP’S NAME AS WELL AS IN DNAME
29.WAQT D EMPS NAME WHO ARE GETTING EVEN SAL
No comments:
Post a Comment