SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Loop with date to begin a procedure

2841475Mar 2 2016 — edited Mar 2 2016

Hi all,

I am kind of newb with procedures and I need a little help.

I wrote a procedure that gets one parameter only(a date), doing some querying - and populate a table a little bit.

I was able to run it manually with a fixed date that I planted but my problem is that I would like to execute it manually with a loop with every eow (every Saturday), from January 1 2016 untill the 27 February.

Thanks in advance evreybody,

Yaniv

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 30 2016

Added on Mar 2 2016

4 comments

442 views