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 vote325 views1 answer
Reindexing all tables sql server
SQL
0 vote290 views1 answer
Postgres can integer fields be negative
SQL
0 vote285 views1 answer
Sql injection payload list github
SQL
2 votes255 views1 answer
SQL column name Postgre
SQL
0 vote300 views1 answer
Parent and child link in mysql
SQL
0 vote266 views1 answer
Sql server system messeges
SQL
0 vote254 views1 answer
Postgresql regular expression special characters
SQL
0 vote277 views1 answer
#1231 - Variable 'sql_mode' can't be set to the value of 'NULL'
SQL
0 vote248 views1 answer
Recursive query herarchical data sql server
SQL
0 vote272 views1 answer
Mac os zsh: command not found: mysql
SQL