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

1 vote151 views2 answers
Sql server backup table
SQL
0 vote194 views1 answer
Which lock mode is not available in sql
SQL
0 vote154 views1 answer
QUERY JPQL
SQL
0 vote156 views2 answers
Sql join on comma separated field
SQL
3 votes182 views3 answers
Update con select postgresql
SQL
2 votes143 views1 answer
Sql update alias
SQL
0 vote210 views3 answers
Select top 10 rows in sql
SQL
13 votes146 views2 answers
Sql count distinct group by
SQL
1 vote166 views1 answer
Postgres get month name from date
SQL
0 vote153 views1 answer
Mysqli::query(): (HY000/1034): Index for table 'db' is corrupt; try to repair it
SQL