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

3 votes286 views2 answers
Oracle sql drop sequence
SQL
0 vote259 views1 answer
Jooq finding lastest value in table
SQL
3 votes304 views2 answers
Oracle grants
SQL
0 vote307 views1 answer
Mysql loop through databases and execute query
SQL
5 votes293 views1 answer
Oracle columns in all_tables
SQL
0 vote279 views1 answer
Postgresql subquery
SQL
0 vote301 views1 answer
Import sql inside hide sql
SQL
2 votes330 views2 answers
Sql lag
SQL
1 vote292 views2 answers
String to date postgres
SQL
0 vote291 views1 answer
Mysql illegal mix of collations for operation 'concat'
SQL