segunda-feira, 1 de agosto de 2022

Oracle - Listar datas do mês

 select TRUNC(SYSDATE)  + level - 1 dt

from   dual

connect by level <= (

  LAST_DAY(SYSDATE) - TRUNC(SYSDATE) + 1

)




Oracle - Listar datas do mês

 select TRUNC(SYSDATE)  + level - 1 dt from   dual connect by level <= (   LAST_DAY(SYSDATE) - TRUNC(SYSDATE) + 1 )