一些数据库的循环方法

一些数据库的循环方法：

Mysql

1. myLoop;
2. myLoop(begin_date (10), end_date (10))
4. ???? v_date ;
5. ???? v_begin_date, v_end_date (10);
6. ???? v_date = begin_date;
7. ???? v_date < end_date do
8. ???????? v_begin_date = DATE_FORMAT(v_date,‘%Y-%m-%d‘);
9. ???????? v_date = DATE_ADD(v_date, 1 );
10. ???????? v_end_date = DATE_FORMAT(v_date,‘%Y-%m-%d‘);
11. ???????? v_begin_date, v_end_date;
12. ????????-- write your sql here!
13. ???? ;
14. ;
15. -- call myLoop(‘2013-08-15‘,‘2013-09-02‘);

?

?

Oracle

2. ???????v_date ;
3. ???????v_begin_date 2(10);
4. ???????v_end_date 2(10);
6. ???????v_date := ‘2014-06-02‘;
7. ??????? v_date < ‘2014-06-20‘ loop
8. ?????????????v_begin_date := to_char(v_date, ‘yyyy-mm-dd‘);
9. ?????????????v_date := v_date + 1;
10. ?????????????v_end_date := to_char(v_date, ‘yyyy-mm-dd‘);
11. ?????????????dbms_output.put_line(v_begin_date||‘ === ‘||v_end_date);
12. ?????????????-- write your sql here!
13. ????????? loop;
14. ?????????;
15. ;