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 votes93 views1 answer
Mysql list users on ubuntu
SQL
0 vote108 views1 answer
Get number of table colums in sql query
SQL
0 vote99 views1 answer
. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (.Net SqlClient Data Provider)
SQL
0 vote109 views1 answer
Get rows from 1 table with other table empty mysql
SQL
0 vote62 views2 answers
Jupyter notebook connect to database
SQL
2 votes115 views1 answer
Sql count having
SQL
0 vote102 views1 answer
Insert array into mysql column
SQL
0 vote126 views1 answer
Sql server information_schema temp tables
SQL
2 votes111 views1 answer
Node and mysql like
SQL
3 votes100 views1 answer
APEX elapsed time
SQL