Technical Blog

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

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