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

2 votes280 views3 answers
Xampp mysql database not starting
SQL
0 vote210 views2 answers
Plsql function that return a table
SQL
0 vote196 views1 answer
Postgres enumerated type
SQL
0 vote214 views1 answer
Postgresql in vs any performance
SQL
5 votes192 views1 answer
Mysql get last day of month
SQL
4 votes246 views1 answer
Mysql query first character
SQL
0 vote195 views1 answer
How to order result of subquery in select
SQL
2 votes238 views5 answers
Tablespace ORACLE
SQL
0 vote229 views1 answer
Insert value in identity
SQL
1 vote219 views1 answer
Get parameter value in mysql trigger
SQL