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

7 votes348 views2 answers
Mysql db size
SQL
0 vote379 views1 answer
Order child below the parent in mysqli
SQL
0 vote356 views1 answer
Selecting from a view SQL
SQL
0 vote328 views1 answer
Mysql command prompt date insert format
SQL
1 vote354 views1 answer
Sql select all from one table and one column from another
SQL
1 vote356 views1 answer
Mysql select for update ejemplo
SQL
0 vote347 views1 answer
Find and replace database table phpmyadmin
SQL
1 vote284 views1 answer
File /etc/init.d/mysql not exists
SQL
1 vote353 views1 answer
Sql server epoch to datetime
SQL
0 vote329 views1 answer
SQL > Manipulação de Tabelas > Constraint
SQL