SELECT EXTRACT(YEAR FROM SYSDATE) + LEVEL||'年' AS year, EXTRACT(YEAR FROM SYSDATE) + LEVEL as nian
FROM DUAL
CONNECT BY LEVEL <=5
UNION
SELECT EXTRACT(YEAR FROM SYSDATE)||'年' AS year,EXTRACT(YEAR FROM SYSDATE) as nian
FROM DUAL
CONNECT BY LEVEL = 0
UNION
SELECT EXTRACT(YEAR FROM SYSDATE) - LEVEL||'年' AS year,EXTRACT(YEAR FROM SYSDATE) - LEVEL as nian
FROM DUAL
CONNECT BY LEVEL <= 5
FROM DUAL
CONNECT BY LEVEL <=5
UNION
SELECT EXTRACT(YEAR FROM SYSDATE)||'年' AS year,EXTRACT(YEAR FROM SYSDATE) as nian
FROM DUAL
CONNECT BY LEVEL = 0
UNION
SELECT EXTRACT(YEAR FROM SYSDATE) - LEVEL||'年' AS year,EXTRACT(YEAR FROM SYSDATE) - LEVEL as nian
FROM DUAL
CONNECT BY LEVEL <= 5
扫一扫
1万+
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
