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 vote154 views1 answer
Rails sql query converstion
SQL
2 votes218 views1 answer
Oracle list grants on package
SQL
4 votes138 views1 answer
Oracle error compilation line
SQL
0 vote144 views1 answer
Django mssql backend
SQL
0 vote138 views1 answer
Flask sqlalchemy. commit does not save changes
SQL
0 vote141 views1 answer
Left join in codeigniter query builder
SQL
0 vote143 views1 answer
Populate db from command line postgres
SQL
1 vote141 views1 answer
Sql select row with max date
SQL
-1 vote151 views1 answer
Adding a new table psql
SQL
3 votes151 views1 answer
Sql online test questions and answers
SQL