Oracle drop sequence if exists

DECLARE
    s_exist NUMBER(1);
BEGIN
    SELECT CASE WHEN exists(SELECT * FROM ALL_SEQUENCES 
                           WHERE SEQUENCE_NAME = 'seq_name') THEN 1
       	ELSE 0 
    END INTO s_exist FROM DUAL;
    IF s_exist = 1 THEN
        EXECUTE IMMEDIATE 'DROP SEQUENCE seq_name';
    END IF;
END;

Similar codes

1 vote162 views1 answer
Sql server if exists update else insert
SQL
6 votes141 views3 answers
Mysql first day of year
SQL
2 votes137 views1 answer
Update trigger
SQL
7 votes143 views2 answers
How to create index mysql
SQL
0 vote134 views1 answer
Postgres regex word boundary
SQL
2 votes153 views2 answers
Postgres timestamp to datetime
SQL
104 votes338 views2 answers
Like in mysql
SQL
4 votes132 views1 answer
Fetch first 10 rows in oracle sql developer
SQL
3 votes161 views3 answers
Sql current year
SQL
1 vote126 views1 answer
Sql server 2012 query history
SQL