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 vote356 views2 answers
SQL BULK INSERT
SQL
1 vote352 views4 answers
Mysqldump 1 table only
SQL
1 vote354 views1 answer
Mysql best tutorial for beginners
SQL
3 votes346 views1 answer
Oracle undo tablespace list by user
SQL
0 vote333 views1 answer
Get all employees if name ends with in sql
SQL
1 vote375 views1 answer
Ora-01950 no privileges on tablespace
SQL
0 vote402 views1 answer
How to use sqlcommand
SQL
5 votes349 views1 answer
Sql asynchronous stored procedure call
SQL
0 vote378 views1 answer
Varchar2 length in oracle
SQL
0 vote365 views1 answer
Mysql export search results
SQL