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

0 vote268 views1 answer
St_buffer mysql
SQL
5 votes244 views2 answers
Create table
SQL
2 votes268 views2 answers
Get all columns from table sql
SQL
1 vote322 views1 answer
Hangfire clear all jobs
SQL
0 vote218 views1 answer
Mysql collation for all languages
SQL
1 vote267 views1 answer
Access denied for user 'root'@'localhost' python sql-connect error
SQL
0 vote279 views1 answer
Postgres list all stored procedures query
SQL
2 votes264 views2 answers
Checking data type in sql server
SQL
0 vote258 views1 answer
1 column values in to 1 single row in sql
SQL
0 vote299 views1 answer
Primary key start from number
SQL