title: How to find if a sequence exists using PL/SQL
body: <p>I need to find using PL/SQL if a specific sequence named e.g. MY_SEQ exits. If the sequence exists then drop it and create a new, or else to just create a new sequence.</p>
  
  <p>E.G. (pseudocode)</p>
  
  <pre><code>IF EXISTS(MY_SEQ) THEN
  BEGIN
     DROP SEQUENCE MY_SEQ;
     CREATE SEQUENCE MY_SEQ...
  END;
  ELSE
  BEGIN
    CREATE SEQUENCE MY_SEQ;
  END;
  </code></pre>