日期:2014-05-17 浏览次数:20968 次
with t as (select 'AAA' a, sysdate b, sysdate + 5 c from dual) select a, trunc(b) + level - 1 from t connect by level <= trunc(c) - trunc(b);