select rownum from dual connect by rownum <= 12 S
select rownum from dual connect by rownum <= 12
SELECT '2016/'||substr('0'||to_char(rownum),-2,2) yymm
FROM DUAL CONNECT BY rownum<=12;
--结束END--
本文标题: 利用Connect By构造数列
本文链接: https://lsjlt.com/news/46842.html(转载时请注明来源链接)
有问题或投稿请发送至: 邮箱/279061341@qq.com QQ/279061341
2024-10-23
2024-10-22
2024-10-22
2024-10-22
2024-10-22
2024-10-22
2024-10-22
2024-10-22
2024-10-22
2024-10-22
回答
回答
回答
回答
回答
回答
回答
回答
回答
回答
0