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

4 votes270 views1 answer
Sql select limit range
SQL
11 votes265 views6 answers
Mysql else if
SQL
0 vote226 views1 answer
Download mysql database to excel in android studio
SQL
0 vote228 views1 answer
Mql5 datetime get hour
SQL
0 vote236 views1 answer
Sqlite higher or equal
SQL
-1 vote271 views3 answers
MAKE TABLE FIT in oracle sql
SQL
0 vote230 views1 answer
Sql server: how to assign value to table variable returned from function
SQL
0 vote228 views1 answer
Mysqldump don't drop table
SQL
8 votes211 views3 answers
Duplicate entry
SQL
1 vote243 views2 answers
Sql queries practice
SQL