Can this sequence be done in Oracle?

Hi ,

I need to create a sequence that will reset it self every day:

For example when it is executed for a certain data it will start from 1..and then always add 1.

If execute it for the day after it will start again from 1..and then always add 1.

I have a table where part of the key is the a date and a sequence number. The application was created in mysql and I was created the sequences manually there but now I am hoping to use Oracles features to acomplish this.

Thanks in advance,

Nick Received on Fri Mar 23 2001 - 09:55:48 CST