oracle基础积累-指定间隔取一天内时间点

场景:
        一天24小时内,每隔15分钟取出一个时间点,去做相应的业务处理,一天共计96个点,.
        本例使用存储过程演示,使用dbms_output.put_line函数输出看效果.
环境:
        Oracle Database 11g; PL/SQL Developer
1.方式一存储过程

CREATE OR REPLACE PROCEDURE PRO_TEST_CURSOR_FOR2(ERRORMSG OUT VARCHAR2) IS
BEGIN
  BEGIN
    ERRORMSG := '';
    FOR V_ID IN 1 .. 96 LOOP
      dbms_output.put_line(to_char(((substr('S' || V_ID, 2, 2) - 1) * 15 /
                                   (24 * 60) + trunc(SYSDATE - 1)),
                                   'yyyy/mm/dd hh24:mi:ss'));
    END LOOP;
  END;
EXCEPTION
  WHEN OTHERS THEN
    ERRORMSG := 'PRO_TEST_CURSOR_FOR2抛出异常: ' || SQLERRM;
END PRO_TEST_CURSOR_FOR2;

2.方式二存储过程

CREATE OR REPLACE PROCEDURE PRO_TEST_CURSOR_FOR2(ERRORMSG OUT VARCHAR2) IS
BEGIN
  BEGIN
    ERRORMSG := '';
    FOR V_ID IN 1 .. 96 LOOP
      dbms_output.put_line(to_char(SYSDATE - 1, 'yyyy/mm/dd') 
                            || ' ' 
                            || substr('0' || floor((V_ID - 1) * 15 / 60),-2,2) 
                            || ':' 
                            || substr('0' || mod((V_ID - 1) * 15, 60), -2, 2) 
                            || ':' 
                            || '00');
    END LOOP;
  END;
EXCEPTION
  WHEN OTHERS THEN
    ERRORMSG := 'PRO_TEST_CURSOR_FOR2抛出异常: ' || SQLERRM;
END PRO_TEST_CURSOR_FOR2; 

3.输出结果,本例输出相同时间格式

2019/09/13 00:00:00
2019/09/13 00:15:00
2019/09/13 00:30:00
2019/09/13 00:45:00
2019/09/13 01:00:00
2019/09/13 01:15:00
2019/09/13 01:30:00
2019/09/13 01:45:00
2019/09/13 02:00:00
2019/09/13 02:15:00
2019/09/13 02:30:00
2019/09/13 02:45:00
2019/09/13 03:00:00
2019/09/13 03:15:00
2019/09/13 03:30:00
2019/09/13 03:45:00
2019/09/13 04:00:00
2019/09/13 04:15:00
2019/09/13 04:30:00
2019/09/13 04:45:00
2019/09/13 05:00:00
2019/09/13 05:15:00
2019/09/13 05:30:00
2019/09/13 05:45:00
2019/09/13 06:00:00
2019/09/13 06:15:00
2019/09/13 06:30:00
2019/09/13 06:45:00
2019/09/13 07:00:00
2019/09/13 07:15:00
2019/09/13 07:30:00
2019/09/13 07:45:00
2019/09/13 08:00:00
2019/09/13 08:15:00
2019/09/13 08:30:00
2019/09/13 08:45:00
2019/09/13 09:00:00
2019/09/13 09:15:00
2019/09/13 09:30:00
2019/09/13 09:45:00
2019/09/13 10:00:00
2019/09/13 10:15:00
2019/09/13 10:30:00
2019/09/13 10:45:00
2019/09/13 11:00:00
2019/09/13 11:15:00
2019/09/13 11:30:00
2019/09/13 11:45:00
2019/09/13 12:00:00
2019/09/13 12:15:00
2019/09/13 12:30:00
2019/09/13 12:45:00
2019/09/13 13:00:00
2019/09/13 13:15:00
2019/09/13 13:30:00
2019/09/13 13:45:00
2019/09/13 14:00:00
2019/09/13 14:15:00
2019/09/13 14:30:00
2019/09/13 14:45:00
2019/09/13 15:00:00
2019/09/13 15:15:00
2019/09/13 15:30:00
2019/09/13 15:45:00
2019/09/13 16:00:00
2019/09/13 16:15:00
2019/09/13 16:30:00
2019/09/13 16:45:00
2019/09/13 17:00:00
2019/09/13 17:15:00
2019/09/13 17:30:00
2019/09/13 17:45:00
2019/09/13 18:00:00
2019/09/13 18:15:00
2019/09/13 18:30:00
2019/09/13 18:45:00
2019/09/13 19:00:00
2019/09/13 19:15:00
2019/09/13 19:30:00
2019/09/13 19:45:00
2019/09/13 20:00:00
2019/09/13 20:15:00
2019/09/13 20:30:00
2019/09/13 20:45:00
2019/09/13 21:00:00
2019/09/13 21:15:00
2019/09/13 21:30:00
2019/09/13 21:45:00
2019/09/13 22:00:00
2019/09/13 22:15:00
2019/09/13 22:30:00
2019/09/13 22:45:00
2019/09/13 23:00:00
2019/09/13 23:15:00
2019/09/13 23:30:00
2019/09/13 23:45:00

以上,感谢.