List of times in Oracle

Oracle Row Generator Techniques is pretty definitive. Here is a nice example to provide 15 minute times in a day:

select to_char(trunc(sysdate)+(level-1)*15/1440, 'HH24:MI') from dual connect by level <= 240;