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 vote175 views1 answer
Mysql command line ubuntu
SQL
5 votes171 views2 answers
Copy data from one database to another
SQL
9 votes173 views4 answers
Add primary key to existing table sql
SQL
2 votes244 views1 answer
Create mysql user on all hosts
SQL
3 votes185 views1 answer
Oracle limit user tablespace
SQL
0 vote178 views1 answer
Reona
SQL
0 vote284 views1 answer
Drop check command
SQL
-1 vote162 views1 answer
How to use update trigger in sql
SQL
0 vote162 views1 answer
Myswql show full processlist
SQL
0 vote177 views1 answer
Select list is not in group by clause and contains nonaggregated column codeigniter
SQL