首页 > 数据库 > 国内数据库 > 我用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;

来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/69947868/viewspace-3075202/ ,如需转载,请注明出处,否则将追究法律责任。