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

12 votes355 views1 answer
Script to add new column in table sql
SQL
0 vote358 views1 answer
Show size of all tables postgres
SQL
0 vote351 views1 answer
Sql server port 1434
SQL
0 vote331 views1 answer
Sql from null to not null
SQL
3 votes349 views1 answer
Mysql replace string in table
SQL
2 votes388 views1 answer
Rails execute sql
SQL
6 votes359 views4 answers
Remove spaces sql server
SQL
1 vote378 views1 answer
Oracle enable job
SQL
0 vote408 views1 answer
Mysql create index lost connection
SQL
2 votes357 views1 answer
Mysql how to store lat,lng
SQL