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 vote236 views1 answer
Sql ssrs
SQL
1 vote206 views1 answer
Increase existing date in sql oracle
SQL
0 vote195 views1 answer
Kotlin sqlite delete row
SQL
0 vote193 views1 answer
Install sql server in ubuntu 20.04
SQL
3 votes194 views1 answer
Laravel paginate raw sql
SQL
0 vote186 views1 answer
How to select a row in sql
SQL
1 vote181 views1 answer
Mysql illegal mix of collations for operation 'join'
SQL
0 vote187 views1 answer
Mysql average from two table
SQL
8 votes227 views1 answer
Mac restore mysql database command line
SQL
0 vote213 views1 answer
Oracle to_number
SQL