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 vote161 views1 answer
Number(10 2) in sql means
SQL
4 votes197 views1 answer
Sql delete multiple conditions
SQL
0 vote177 views1 answer
Oracle cpu metric
SQL
8 votes209 views4 answers
Convert date to dd/mm/yyyy sql
SQL
2 votes179 views2 answers
Install sqlalchemy
SQL
2 votes193 views1 answer
Create delete procedure mysql
SQL
6 votes172 views1 answer
Postgres get size of database
SQL
38 votes240 views4 answers
Count sql
SQL
0 vote183 views1 answer
Query to count the number of rows in a table in sqlalchemy
SQL
0 vote182 views1 answer
Docker open terminal mysql server
SQL