select to_char(sysdate, ‘yyyy-’) || lpad(level, 2, 0) datevalue
from dual
connect by level < 13
oracle 查询一年12个月的sql
最新推荐文章于 2023-08-12 17:59:49 发布
select to_char(sysdate, ‘yyyy-’) || lpad(level, 2, 0) datevalue
from dual
connect by level < 13