Advertisement
Catkinnn

Untitled

Jan 12th, 2024 (edited)
1,586
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. SELECT   ID, TRUNC(CAST(START_DATE AS DATE), 'DD')+LEVEL - 1 AS DAY
  2. FROM EOM_RUN_RECORDS
  3. CONNECT BY LEVEL <=TRUNC(CAST(END_DATE AS DATE) ,'DD')-TRUNC(CAST(START_DATE AS DATE) ,'DD')
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement