I am designing an order delivery system, and I have hit a snag...

I need to generate an invoice number with the following format (either in oracle or in business logic) YYYYDDNNNNN

like 040100001 040100002 etc etc

Hoe can this be done... the more IM thinking about the more frustrated I become


kind regards
Henrik