Printing every Monday from 1998 to today

[erixire]

Hi,

Is it possible with Oracle to print every monday from a certain date (1 january 1998) to today in a kind of list like this:

01-01-1998
08-01-1998
15-01-1998
...


Thanks a lot,

 

[karluk]

Something like the following should work.

declare list_monday date := '01-jan-1998';
begin
while list_monday <= sysdate
loop
dbms_output.put_line(list_monday);
list_monday := next_day(list_monday,'Monday');
end loop;
end;