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

1 vote122 views2 answers
Mysql add column tinyint default 0
SQL
1 vote112 views1 answer
Sql server insert into temp table
SQL
-1 vote107 views4 answers
Restart mysql server ubuntu
SQL
0 vote108 views1 answer
How to query without duplicate rows in sql
SQL
0 vote95 views1 answer
Sql join on a subquery
SQL
8 votes97 views2 answers
Sqlsrv default port
SQL
0 vote95 views1 answer
Postgresql stored procedure update table values
SQL
4 votes86 views1 answer
Invalid reference to FROM-clause entry for table "unidades
SQL
0 vote99 views1 answer
Mariadb datetime change to microseconds
SQL
0 vote142 views1 answer
How to add auto increment primary key
SQL