select TRUNC(SYSDATE) + level - 1 dt
from dual
connect by level <= (
LAST_DAY(SYSDATE) - TRUNC(SYSDATE) + 1
)
Solucionando problemas que os clientes não sabem que têm, de uma forma que eles jamais entenderiam...
select TRUNC(SYSDATE) + level - 1 dt
from dual
connect by level <= (
LAST_DAY(SYSDATE) - TRUNC(SYSDATE) + 1
)
select TRUNC(SYSDATE) + level - 1 dt from dual connect by level <= ( LAST_DAY(SYSDATE) - TRUNC(SYSDATE) + 1 )