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 vote45 views1 answer
Mysql calculated column
SQL
1 vote48 views1 answer
Table information in sql server
SQL
1 vote42 views3 answers
String to int mysql
SQL
0 vote85 views1 answer
How to make sure two tables have same exact data in sql
SQL
0 vote42 views1 answer
Postgres float to int
SQL
14 votes42 views3 answers
How to add default constraint in mysql
SQL
0 vote48 views1 answer
Hou to run job from cmd .exe sql server jop
SQL
0 vote41 views1 answer
Postgres list all stored procedures query
SQL
1 vote48 views1 answer
Get the User Name and Domain Name from an Email Address
SQL
1 vote51 views1 answer
Mysql count multiple columns in one query
SQL