SELECT ENAME
FROM EMP
WHERE LENGTH(ENAME)=4;
SELECT ENAME,JOB
FROM EMP
WHERE LENGTH(JOB)=7;
SELECT LENGTH(PROGRAMMINGWITHKALYAN)-LENGTH(REPLACE(‘PROGRAMMINGWITHKALYAN ’,’A’))
FROM DUAL;
SELECT JOB
FROM EMP
WHERE SUBSTR(JOB,-3)=’MAN’;
SELECT JOB
FROM EMP
WHERE SUBSTR(JOB,1,3)=’MAN’;
SELECT ENAME
FROM EMP
WHERE LENGTH(ENAME)-LENGTH(REPLACE(ENAME,'L'))=1

(OR)

SELECT ENAME
FROM EMP
WHERE INSTR(ENAME,’L’,1,1)>0 AND INSTR(ENAME,’L’,1,2)=0;
SELECT DNAME
FROM DEPT
WHERE INSTR(DNAME,'O',1)>0;
SELECT CONCAT(ENAME,CONCAT(' WORKING AS A ',CONCAT(' CLERK EARNS 3000 IN DEPTNO ',DEPTNO)))
FROM EMP
WHERE ENAME='SCOTT';
SELECT LENGTH(HELLLLL)-LENGTH(REPLACE(HELLLLL,'L'))
FROM DUAL;
SELECT JOB
FROM EMP
WHERE INSTR(JOB,'MAN',1)>0;
SELECT JOB
FROM EMP
WHERE SUBSTR(JOB,1,3)=’MAN’;
SELECT JOB
FROM EMP
WHERE SUBSTR(JOB,-3)=’MAN’;
SELECT CONCAT(LOWER(SUBSTR('KALYAN',1,3)),
SUBSTR('KALYAN',4)
FROM DUAL;
SELECT CONCAT(ENAME,CONCAT(' IS A ' , CONCAT( JOB , CONCAT(' AND GETS A
SALARY OF ',2000))))
FROM EMP
WHERE ENAME='SMITH' AND JOB='CLERK';
SELECT ENAME,HIREDATE
FROM EMP
WHERE TO_CHAR(HIREDATE,'DY')='WED';
SELECT ENAME
FROM EMP
WHERE MOD(TO_CHAR(HIREDATE,'YY'),4)=0;
SELECT ENAME,HIREDATE
FROM EMP
WHERE TO_CHAR(HIREDATE , 'DY')='SUN' AND TO_CHAR(HIREDATE,'MON')='MAY';
SELECT TO_CHAR(HIREDATE,'MON-DD-YYYY')
FROM EMP;
SELECT CONCAT(LOWER(SUBSTR(ENAME,1,LENGTH(ENAME)/2)),REVERSE(SUBSTR(ENAME,LENGTH(ENAME)/2+1)))
FROM EMP;
SELECT SUBSTR(ENAME,-3)
FROM EMP
WHERE JOB=’MANAGER’;
SELECT ENAME
FROM EMP
WHERE SUBSTR(ENAME,-1)=’S’;
SELECT ENAME
FROM EMP
WHERE SUBSTR(ENAME,-1)IN (’S’,’N’);
SELECT ENAME
FROM EMP
WHERE SUBSTR(ENAME,1,1)IN (’A’,’E’,’I’,’O’,’U’);
SELECT ENAME, SUBSTR(ENAME,1,LENGTH(ENAME)/2)
FROM EMP;
SELECT ENAME, SUBSTR(ENAME,LENGTH(ENAME)/2+1)
FROM EMP;
SELECT ENAME, SUBSTR(ENAME,2,LENGTH(ENAME)-2)
FROM EMP;
SELECT ENAME
FROM EMP
WHERE INSTR(ENAME,’A’,1,1) >0;
SELECT ENAME,DNAME
FROM EMP E,DEPT D
WHERE E.DEPTNO=D.DEPTNO AND INSTR(ENAME,’O’,1)>0 AND INSTR(DNAME,’O’,1)>0;
SELECT ENAME
FROM EMP
WHERE MOD(LENGTH(ENAME),2)=0;