我用SQL画出了对女神节的祝福，很哇塞！

你从来不是节日限定惊喜，而是永恒的人间星光。

3.8节快乐，永远优先爱自己的你，那么这里小编作为一名DBA，也用SQL画出了对女神们最贴心祝福！

女神节日祝福

SELECT '❤ ❤ ❤  女神节快乐！ ❤ ❤ ❤' AS love FROM DUAL
UNION ALL
SELECT RPAD(' ', 6) || '❤️      ❤️' FROM DUAL
UNION ALL
SELECT RPAD(' ', 4) || '❤️            ❤️' FROM DUAL
UNION ALL
SELECT RPAD(' ', 2) || '❤️                ❤️' FROM DUAL
UNION ALL
SELECT '❤️                    ❤️' FROM DUAL
UNION ALL
SELECT RPAD(' ', 2) || '❤️                ❤️' FROM DUAL
UNION ALL
SELECT RPAD(' ', 4) || '❤️            ❤️' FROM DUAL
UNION ALL
SELECT RPAD(' ', 6) || '❤️      ❤️' FROM DUAL
UNION ALL
SELECT RPAD(' ', 8) || '❤️' FROM DUAL
UNION ALL
SELECT '愿所有女性：如星辰璀璨，如玫瑰铿锵，活出自我精彩！' FROM DUAL;

经典爱心

SELECT LISTAGG(
         CASE 
           WHEN x=5 AND y=5 THEN TO_CHAR(SYSDATE,'YYYY-MM-DD')
           WHEN POWER(x-5,2) + POWER(y-5,2)*0.6 < 10 
             THEN '❤️'
           ELSE '  '
         END
       ) WITHIN GROUP (ORDER BY x) AS classic_heart
FROM (SELECT LEVEL x FROM dual CONNECT BY LEVEL <=10)
CROSS JOIN (SELECT LEVEL y FROM dual CONNECT BY LEVEL <=10)
GROUP BY y;

多语言花束

SELECT SUBSTR(
' 🌸 '||
         CASE MOD(LEVEL,3)
           WHEN 0 THEN ' 愿你自由绽放'
           WHEN 1 THEN ' You are the universe''s best design'
           WHEN 2 THEN ' あなたは完璧だ'
         END||' 🌸 ',
         1,LEVEL*2
       ) AS multilingual
FROM dual 
CONNECT BY LEVEL<=5
UNION ALL
SELECT LPAD('✿',LEVEL*2,'|') FROM dual CONNECT BY LEVEL<=3;

动态跳动爱心

SELECT LISTAGG(shape, CHR(10)) WITHIN GROUP (ORDER BY lv) AS beating_heart
FROM (
    SELECT LEVEL AS lv,
           CASE 
               WHEN LEVEL IN (3,7) THEN '❤️ 愿你永远闪耀 ❤️'
               ELSE RPAD(' ', 10 - ABS(5 - LEVEL)) 
                    || SUBSTR('❤️❤️❤️❤️', 1, 2*LEVEL) 
                    || RPAD(' ', LEVEL) 
           END AS shape
    FROM dual 
    CONNECT BY LEVEL <= 9
);

数据流爱心

WITH grid AS (
  SELECT x, y, 
         CASE 
           WHEN MOD(x,3)=0 AND MOD(y,2)=0 THEN 
             TRUNC(DBMS_RANDOM.VALUE(1,100))||'%'
           WHEN (POWER((x-15),2) + POWER((y-20)/1.2,2)) < 200
             THEN '❤️'
           ELSE '     '
         END AS cell
  FROM (SELECT LEVEL x FROM dual CONNECT BY LEVEL <=30)
  CROSS JOIN (SELECT LEVEL y FROM dual CONNECT BY LEVEL <=30)
)
SELECT LISTAGG(cell, ' ') WITHIN GROUP (ORDER BY x) AS data_heart
FROM grid
GROUP BY y;

更多内容请关注视频号 

👇👇👇👇