How to reset the sequence value when a date is changed ? (Urgent)
I have a requirement where my procedure needs to print the invoices for the customers at a routine process daily.
Assume that this procedure will run n number of times per a day. Inside the procedure I should have a
default value which has to be printed on the bills. It should have the current system date + counter.
Example 10072004 || 0001 -----------------> 100720040001
The value of the counter should be reset to zero when the current system date has been changed.I can use the
counter from the sequence generator, but how can I reset to zero and how to check the system date.