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 votes297 views1 answer
How to open database
SQL
0 vote282 views7 answers
10 random questions use python and SQL
SQL
0 vote300 views1 answer
Postgress append string in select
SQL
0 vote309 views1 answer
Subquery aggregation
SQL
4 votes339 views6 answers
List all tables in postgres
SQL
1 vote344 views3 answers
How to reset id column in sql server
SQL
7 votes307 views1 answer
Oracle reset sequence
SQL
0 vote286 views1 answer
Call to undefined function mysql_query() in D:\xampp\htdocs\image\index.php:11 Stack trace: #0 {main} thrown in site:stackoverflow.com
SQL
1 vote283 views1 answer
MySQL AND Operator
SQL
0 vote311 views1 answer
Sql server roles and users
SQL