Oracle如何获取某个月的日期

SELECT
	CONCAT (
		201901,
		TO_CHAR (LPAD(t1.rn, 2, '0'))
	) dd
FROM
	(
		SELECT
			ROWNUM rn
		FROM
			dual CONNECT BY ROWNUM <= (
				SELECT
					TO_NUMBER (
						TO_CHAR (
							LAST_DAY (TO_DATE(201901, 'yyyymm')),
							'dd'
						)
					) dd
				FROM
					dual
			)
	) t1

输出结果如下图所示

可以根据“年月”格式自动输出每个月的日期，非常方便