title: Reset auto increment sequence pl-sql
body: <p>How can i reset auto increment primary key ?</p>
  
  <p>I have a doc_id_seq and a doc_pk_trg trigger like that:</p>
  
  <pre><code>CREATE SEQUENCE doc_id_seq START WITH 1;
  
  CREATE OR REPLACE TRIGGER doc_pk_trg
  BEFORE INSERT ON TFIDF FOR EACH ROW
  BEGIN  
   IF :NEW.doc_id IS NULL THEN    
     SELECT doc_id_seq.NEXTVAL INTO :NEW.doc_id FROM DUAL;  
       END IF;
       END;
   /
  </code></pre>
  
  <p>I want to learn reset the sequence  . How can I do this ? </p>