I need to do a procedure in sql with dates

Question

I need to make a procedure in sql that shows me how to fill a table of dates, in a column the dates appear with intervals of 1 by 1, the column that I don't know how to fill is the date_week which should appear like this from: 12-01 -2011 to 01-18-2011 and every 7 days you must change the range of the week from: 01-19-2011 to 01-25-2011, how can i do this?

Answer 1

Steven Feuerstein's PL/SQL tutorial series, the post about handling dates:

https://blogs.oracle.com/connect/post/working-with-dates-in-plsql

Answer 2

Attempt?