方法一
通过dual
SELECT
LPAD(LEVEL,2,'0') AS dateMon
FROM
dual
CONNECT BY
LEVEL < 13
方法二
通过case then
SELECT * FROM
(
with
方法一
通过dual
SELECT
LPAD(LEVEL,2,'0') AS dateMon
FROM
dual
CONNECT BY
LEVEL < 13
方法二
通过case then
SELECT * FROM
(
with