title: How do I automatically reset a sequence's value to 0 every year in Oracle 10g?
body: <p>As in the question, how do I automatically reset an Oracle sequence's value back to 0 every year in Oracle 10g? </p>
  
  <p>I'm using the sequence to generate an identifier in the format <code>YYYY&lt;sequence value&gt;</code> and the sequence value has to be reset to 0 every year. </p>
  
  <p><code>YYYY</code> is obtained from java and concatenated with the sequence value from Oracle. The format of the identifier can't be changed due to external 3rd party requirements. Thanks for any help in advance.</p>