Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Winner
set serveroutput on
declare
l_date date;
begin
l_date := to_date('22/09/2001','DD/MM/YYYY');
For l in 0..round(months_between(to_date('15/05/2002','DD/MM/YYYY') ,
to_date('22/09/2001','DD/MM/YYYY'))) Loop
dbms_output.put_line(to_char(to_date('22/09/2001','DD/MM/YYYY')+(l*30),'YYYY
MM'));
End Loop;
End;
/
Received on Mon Sep 03 2001 - 09:29:38 CDT
![]() |
![]() |