Oracle drop sequence if exists

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

6 votes166 views1 answer
Oracle rank() over (partition)
SQL
0 vote286 views1 answer
Postgresql powershell query
SQL
0 vote179 views1 answer
Update using case in mysql
SQL
0 vote172 views1 answer
SQL get max per id
SQL
3 votes187 views2 answers
MySQL query to get column names
SQL
3 votes258 views1 answer
Oracle cannot access v$session
SQL
0 vote192 views1 answer
Alter check command
SQL
0 vote200 views1 answer
Oracle dynamic select into
SQL
3 votes182 views3 answers
Sql last week
SQL
1 vote176 views1 answer
Mysql sort by date column
SQL