Skip to main content
Share Your Experience: Take the 2024 Developer Survey
Del's user avatar
Del's user avatar
Del's user avatar
Del
  • Member for 4 years, 1 month
  • Last seen more than 1 year 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.
5
bronze badges
9
Score
4
Posts
100
Posts %
4
Score
1
Posts
25
Posts %
4
Score
1
Posts
25
Posts %
4
Score
1
Posts
25
Posts %
3
Score
1
Posts
25
Posts %
1
Score
1
Posts
25
Posts %
Top posts
answer
4
Apr 8, 2020
answer
1
Aug 20, 2021
answer
1
Oct 11, 2021