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 vote291 views1 answer
Less than date query sqlachemy
SQL
0 vote237 views2 answers
Delete the last item in a table sql
SQL
0 vote321 views1 answer
Database schema for mcqs type exam in sql
SQL
2 votes293 views5 answers
SQL trigger
SQL
1 vote340 views4 answers
How to check table in postgresql from terminal
SQL
4 votes311 views1 answer
Sql delete multiple conditions
SQL
0 vote311 views1 answer
Oracle NLS_CHARACTERSET
SQL
19 votes304 views6 answers
Mysql if null
SQL
0 vote278 views1 answer
Get week day name sql server
SQL
0 vote292 views1 answer
Oracle cpu metric
SQL