Del's user avatar
Del's user avatar
Del's user avatar
Del
  • Member for 2 years, 1 month
  • Last seen more than 2 years ago
  • New Jersey, USA
About

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;
Badges
This user doesn’t have any gold badges yet.
This user doesn’t have any silver badges yet.
2
bronze badges
Top tags
0
Score
1
Posts
100
Posts %