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 vote274 views1 answer
Firebird where
SQL
1 vote275 views1 answer
Mysql strict_trans_tables
SQL
1 vote287 views2 answers
Extract weekday from date in sql
SQL
10 votes272 views2 answers
Show tables in schema oracle
SQL
0 vote248 views1 answer
Oracle sql date summer time
SQL
5 votes301 views6 answers
In operator sql
SQL
0 vote311 views1 answer
Database disk image is malformed sqlite fix ubuntu
SQL
2 votes252 views1 answer
Insert from table tsql
SQL
0 vote275 views2 answers
Sqlite unique
SQL
0 vote259 views2 answers
Sql server select where date
SQL