SUBSTRING
[Link] ALL THE EMPLOYEES NAME ALONG WITH THAT DISPLAY FIRST AND LAST CHARACTERS
FROM THE EMPLOYEES NAME WITHOUT USING LIKE OPERATOR?
SELECT ENAME,SUBSTR(ENAME,1,1),SUBSTR(ENAME,-1,1) FROM EMP;
[Link] ALL THE EMPLOYEES WHOSE NAME STARTS WITH LETTER 'S' WITHOUT USING LIKE
OPERATOR ?
SELECT * FROM EMP WHERE SUBSTR(ENAME,1,1)='S';
[Link] ALL THE EMPLOYEES WHOSE SALARY IS ENDING WITH 0 WITHOUT USING LIKE
OPERATOR?
SELECT * FROM EMP WHERE SUBSTR(SAL,-1,1)=0;
[Link] ALL THE EMPLOYEES WHOSE NAME STARTS WITH LETTER A AND ENDS WITH LETTER N
WITHOUT USING LIKE OPERATOR?
SELECT * FROM EMP WHERE SUBSTR(ENAME,1,1)='A' AND SUBSTR(ENAME,-1,1)='N';
[Link] TO DISPLAY ALL THE EMPLOYEES WHOSE NAME CONTAINS LETTER L IN THE SECOND
POSITION WITHOUT USING LIKE OPERATOR?
SELECT * FROM EMP WHERE SUBSTR(ENAME,2,1)='L';
[Link] ALL THE EMPLOYEES WHO ARE SALESMAN HAVING LETTER 'E' AS THE LAST BUT ONE
CHARACTER IN THEIR NAME WITHOUT USING LIKE OPERATOR?
SELECT * FROM EMP WHERE JOB='SALESMAN' AND SUBSTR(ENAME,-2,1)='E';
[Link] ALL THE EMPLOYEES WHO ARE HIRED DURING THE YEAR 81 WITHOUT USING LIKE
OPERATOR?
SELECT * FROM EMP WHERE SUBSTR(HIREDATE,-2,2)='81';
[Link] ALL THE EMPLOYEE WHO ARE NOT HIRED IN THE YEAR OF 82 WITHOUT USING LIKE
OPERATOR?
SELECT * FROM EMP WHERE SUBSTR(HIREDATE,-2,2)<>'82';
[Link] 1ST CHARACTER OF EVERY EMPLOYEE NAME?
SELECT SUBSTR(ENAME,1,1) FROM EMP;
[Link] LAST CHARACTER OF EVERY EMPLOYEE NAME?
SELECT SUBSTR(ENAME,-1,1) FROM EMP;
LENGTH
1) DISPLAY ALL THE EMPLOYEES WHOSE NAME IS HAVING EXACTLY 5 CHARACTERS IN IT
WITHOUT USING LIKE OPERATOR?
SELECT * FROM EMP WHERE LENGTH(ENAME)=5;
2. WAQT TO DISPLAY FIRST HALF OF EMPLOYEE NAMES
SELECT SUBSTR(ENAME,1,LENGTH(ENAME)/2) FROM EMP;
3. WAQT TO DISPLAY SECOND HALF OF EMPLOYEE NAMES
SELECT SUBSTR(ENAME,LENGTH(ENAME)/2+1,LENGTH(ENAME)) FROM EMP;
[Link] LAST CHARACTER OF EVERY EMPLOYEE NAME WITHOUT USING -1?
SELECT SUBSTR(ENAME,LENGTH(ENAME),1) FROM EMP;
REPLACE QUESTIONS
[Link] TO RETRIEVE ALL THE EMPLOYEES NAME & JOB WHILE RETRIEVING REPLACE SALES TO
SPIDER?
SELECT ENAME,REPLACE(JOB,'SALES','SPIDER') FROM EMP;
[Link] TO DISPLAY ALL THE ENAME WHILE DISPLAYING REPLACE CHARACTER 'S' TO '$’?
SELECT ENAME,REPLACE(ENAME,'S','$') FROM EMP;
[Link] to count number of time 'A' is present in 'MALAYALAM’
[Link] REPLACE 'A' CHARACTER WITH 'X' CHARACTER FOR EVERY EMPLOYEE NAME?
SELECT REPLACE(ENAME,'A','X') FROM EMP;
[Link] TO REMOVE 'A' CHARACTER FROM EVERY EMPLOYEE NAME?
SELECT REPLACE(ENAME,'A','') FROM EMP;
[Link] LENGTH OF EVERY EMPLOYEE NAME AFTER REMOVING 'A' CHARACTER FROM IT?
SELECT LENGTH(REPLACE(ENAME,'A','')) FROM EMP;