SQL-Notes-and-Queries/SQL 14.txt at main · VISWA-R-R/SQL-Notes-and-Queries · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
SQL 14

1. DISPLAY NAMES OF THE EMPLOYEES IF NAME STARTS WITH VOWELS

SELECT ENAME
FROM EMP
WHERE REGEXP_LIKE(ENAME,'^[AEIOU]');

2. DISPLAY NAMES OF THE EMPLOYEES IF NAME ENDS WITH VOWELS

SELECT ENAME
FROM EMP
WHERE REGEXP_LIKE(ENAME,'[AEIOU]$');

3. DISPLAY NAMES OF THE EMPLOYEES IF NAME DOESNOT STARTS WITH VOWELS

SELECT ENAME
FROM EMP
WHERE NOT REGEXP_LIKE(ENAME,'^[AEIOU]');

4. DISPLAY NAMES OF THE EMPLOYEES IF NAME DOESNOT ENDS WITH VOWELS

SELECT ENAME
FROM EMP
WHERE NOT REGEXP_LIKE(UPPER(ENAME),'[AEIOU]$');

5. DISPLAY NAMES OF THE EMPLOYEES IF NAME STARTS WITH VOWELS AND ENDS WITH VOWELS

SELECT ENAME
FROM EMP
WHERE REGEXP_LIKE(ENAME,'^[AEIOU].*[AEIOU]$');

6. DISPLAY NAMES OF THE EMPLOYEES IF NAME DOESNOT STARTS WITH VOELS BUT ENDS WITH VOWELS

SELECT ENAME
FROM EMP
WHERE NOT REGEXP_LIKE(ENAME,'^[AEIOU]') AND REGEXP_LIKE(ENAME,'[AEIOU]$');

7. DISPLAY NAMES OF THE EMPLOYEES IF NAME STARTS WITH VOWELS BUT DOESNOT ENDS WITH VOWELS

SELECT ENAME
FROM EMP
WHERE REGEXP_LIKE(ENAME,'^[AEIOU]') AND NOT REGEXP_LIKE(ENAME,'[AEIOU]$');

8. DISPLAY NAMES OF THE EMPLOYEES IF NAME DOESNOT STARTS WITH VOWELS AND DOESNOT ENDS WITH VOWELS

SELECT ENAME
FROM EMP
WHERE NOT REGEXP_LIKE(ENAME,'^[AEIOU]') AND NOT REGEXP_LIKE(ENAME,'[AEIOU]$');