Drop sequence

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 vote251 views1 answer
Debian 10 install postgresql 2ndquadrant
SQL
0 vote259 views2 answers
Close external port 3306 with iptables
SQL
2 votes251 views1 answer
Merge two columns in sql oracle
SQL
5 votes257 views1 answer
Minecraft java port number
SQL
2 votes296 views1 answer
Find column in all stored procedures sql server
SQL
-1 vote250 views1 answer
Mysql #1064 error
SQL
0 vote282 views1 answer
How to get column name in db from an sqlalchemy attribute model
SQL
0 vote268 views1 answer
#1231 - Variable 'sql_mode' can't be set to the value of 'NULL'
SQL
0 vote272 views1 answer
Set column in all row mysql
SQL
4 votes250 views1 answer
Sql query to make a existing column auto increment
SQL