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 vote280 views1 answer
Tsql create unique index composite
SQL
1 vote198 views1 answer
Database Queries
SQL
0 vote203 views1 answer
Postgres 11 add primary key
SQL
0 vote221 views1 answer
Top 3 salary in sql
SQL
0 vote225 views1 answer
Leftjoin in sql
SQL
9 votes228 views4 answers
Last mysql
SQL
0 vote310 views2 answers
Reduce size of SQL server log file truncate - Source :NAYCode.com
SQL
2 votes232 views1 answer
Sql skip the first row
SQL
12 votes198 views4 answers
SQL Where
SQL
0 vote210 views1 answer
GROUP BY postgres
SQL