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 vote233 views2 answers
Create-toys-table-with-toy_name-column
SQL
0 vote239 views4 answers
First max salary in sql
SQL
6 votes215 views1 answer
Rank function in oracle with example
SQL
2 votes235 views1 answer
When matched in sql server
SQL
0 vote223 views1 answer
Alasql delete column
SQL
1 vote221 views1 answer
Oracle aleter trigger ora-01031
SQL
19 votes235 views2 answers
Mysql tinyint max value
SQL
-3 votes220 views1 answer
Remove spaces sql 2008
SQL
0 vote232 views1 answer
Sql last 3 rows
SQL
0 vote234 views1 answer
Pgsql is not permitted to log in
SQL