Del

1,529
reputation
1
9
18

Solutions Architect for a large healthcare company. Mostly deal with large data in Oracle with a web-based front-end.

SELECT LISTAGG(CASE
       WHEN 2 = LEVEL THEN CHR(ASCII(DUMMY)-39)
       WHEN LEVEL IN (SQRT(ASCII('$')), 14) THEN CHR(101)
       WHEN LEVEL < 10 AND MOD(LEVEL, 3) = 0 THEN CHR(32)
       WHEN LEVEL = 4 THEN CHR(81)
       WHEN LEVEL = (SELECT count(1) FROM v$version) THEN CHR(117)
       WHEN LEVEL = 7 OR LEVEL = 11 OR LEVEL = 15 THEN CHR(114)
       WHEN LEVEL = 8 THEN CHR(121)
       WHEN LEVEL = LENGTH(TO_CHAR(SYSDATE, 'MM/DD/YYYY')) THEN CHR(87)
       WHEN LEVEL = 12 THEN CHR(105)
       WHEN POWER(LEVEL, 2) = LEVEL THEN CHR(35)
       ELSE CHR(116)
     END) WITHIN GROUP (ORDER BY LEVEL) AS TITLE
FROM DUAL
CONNECT BY LEVEL < 16;