Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Winner

Winner

From: cf <news_at_sitinfo.com>
Date: Mon, 3 Sep 2001 16:29:38 +0200
Message-ID: <9n05qr$h7r$1@reader1.fr.uu.net>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US