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

0 vote207 views1 answer
Bidirectional outer join sql
SQL
1 vote184 views2 answers
Mysql does sentance contain word
SQL
-1 vote228 views1 answer
Mysql faster insert
SQL
0 vote201 views1 answer
Microsoft sql server python connection
SQL
5 votes180 views4 answers
Select random rows sql
SQL
8 votes205 views1 answer
Oracle tablespace datafile max size
SQL
3 votes181 views1 answer
What is having clause
SQL
0 vote218 views1 answer
Database schema for mcqs type exam in sql
SQL
5 votes178 views1 answer
Mysql get last day of month
SQL
5 votes183 views1 answer
Oracle generate list of dates in between a date range
SQL