Oracle列出指定日期段内的日期
SELECT TO_CHAR(to_date('2015/08/01', 'yyyy/mm/dd') + (level - 1), 'yyyy/mm/dd') DD
FROM dual CONNECT BY TRUNC(to_date('2015/08/01', 'yyyy/mm/dd')) + level - 1 < TRUNC(to_date('2015/08/10', 'yyyy/mm/dd'))本文共 271 字，大约阅读时间需要 1 分钟。
Oracle列出指定日期段内的日期
SELECT TO_CHAR(to_date('2015/08/01', 'yyyy/mm/dd') + (level - 1), 'yyyy/mm/dd') DD
FROM dual CONNECT BY TRUNC(to_date('2015/08/01', 'yyyy/mm/dd')) + level - 1 < TRUNC(to_date('2015/08/10', 'yyyy/mm/dd'))转载于:https://www.cnblogs.com/canwyq/p/4718493.html