I want to do a loop in Oracle to cover a range of dates and run a query using each date as a parameter - something like the following.
for d in [a range of date]:
INSERT INTO aTable SELECT * FROM anotherTable WHERE date = $d
Can anyone help me to translate the above pseudo code into valid Oracle PL/SQL? Thanks.