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

1 vote168 views1 answer
ELECT list is not in GROUP BY clause and contains nonaggregated column 'schogdsw_db.SE.name' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
SQL
0 vote173 views1 answer
Désinstaller postgresql linux
SQL
0 vote151 views1 answer
<script>alert
SQL
-1 vote174 views1 answer
Round up and down sql
SQL
0 vote166 views1 answer
INSERT INTO GBP Plus(Index Change) VALUES( AND((SELECT NUMINDEX FROM GBP WHERE ID>ID-1) - (SELECT NUMINDEX FROM GBP WHERE ID=ID ))
SQL
1 vote172 views1 answer
Convert epoch to date in sql server
SQL
5 votes151 views1 answer
List foreign key oracle
SQL
3 votes166 views1 answer
Delete all content in table mysql
SQL
10 votes185 views4 answers
Mysql if else
SQL
0 vote139 views1 answer
CREATE MULTIPLE FK
SQL