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.

E.G. (pseudocode)

```
IF EXISTS(MY_SEQ) THEN
BEGIN
   DROP SEQUENCE MY_SEQ;
   CREATE SEQUENCE MY_SEQ...
END;
ELSE
BEGIN
  CREATE SEQUENCE MY_SEQ;
END;

```