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 BY level <= p_to_date – p_from_date 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’) […]

continue reading.....