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

7 votes123 views1 answer
Sql server convert string to date
SQL
0 vote125 views1 answer
Mysql where don't have string
SQL
0 vote131 views1 answer
T-sql conditional order by multiple columns
SQL
4 votes143 views1 answer
Sql quote in string
SQL
0 vote91 views1 answer
Import csv to mysql
SQL
1 vote115 views1 answer
Firebase bigquery cloud message
SQL
7 votes214 views1 answer
Oracle alter sequence restart start with
SQL
0 vote157 views1 answer
Sql server delete records with specific date
SQL
0 vote136 views1 answer
How to create a new shema using query languaage
SQL
0 vote126 views1 answer
Xampp mysql version
SQL