title: Question Regarding Oracle Sequence
body: <p>We already have a sequence in the database, now I have to modify that sequence so that i start from a specific value which i will be fetching from the db. I have written following code</p>
  
  <pre><code>DECLARE
    i_Seq   INTEGER;
  BEGIN
    SELECT MAX (col_id) + 1 INTO i_Seq from Table;
  
    EXECUTE IMMEDIATE 'CREATE SEQUENCE SEQHDR MINVALUE '|i_Seq|' MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH '|i_Seq|' CACHE 20 NOORDER NOCYCLE'
  END;
  /
  </code></pre>
  
  <p>I have following questions.</p>
  
  <ol>
  <li>Do i have to drop old sequence first or oracle will do it by itself?</li>
  <li>The <em>start with</em> clause in sequence creation. Am i using it right? or i can replace it with any number? </li>
  </ol>