The original problematic line : select p_from_date + level - 1 dt from ( select to_date('1980-11-01 00:00:00','yyyy-mm-dd hh24:mi:ss') as p_from_date, to_date( '1980-11-03 00:00:00','yyyy-mm-dd hh24:mi:ss') as p_to_date from dual ) connect
Every software has a story
The original problematic line : select p_from_date + level - 1 dt from ( select to_date('1980-11-01 00:00:00','yyyy-mm-dd hh24:mi:ss') as p_from_date, to_date( '1980-11-03 00:00:00','yyyy-mm-dd hh24:mi:ss') as p_to_date from dual ) connect