Technical Blog

SELECT deptno, LTRIM(SYS_CONNECT_BY_PATH(ename, ','), ',') employees FROM ( SELECT deptno, ename, ...

To get the higher manager of a particular employee select yy.empno,yy.mgr,yy.ename,rt.empno,rt.mgr,rt.ename from (select * from emp t conne...

Alphabets WITH AlphaBet AS ( SELECT CHR((ROWNUM + 64)) AS Character FROM DUAL CONNECT BY level SELECT * FROM AlphaBet; -------------...