title: How to prefix no of zeros with a variable data
body: <p>I have oracle sequence <code>test</code> as<code>CREATE  SEQUENCE test START WITH 1 INCREMENT BY 1 MINVALUE 1 MAXVALUE 99999 NOCYCLE NOORDER;</code> and i have to insert N number of records into a table with value <code>10D00001</code> however for each record the last 5 digits should be incremented. For an example </p>
  
  <pre><code>insert into test1 values('10D00001');
  insert into test1 values('10D00002');
  insert into test1 values('10D00003');
  insert into test1 values('10D00004');
  ... N
  </code></pre>
  
  <p>Can anyone help me how to prefix <code>n</code> no of <code>0</code> if the sequence value is less than 5.</p>