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 vote338 views1 answer
Excel export from sql using python
SQL
1 vote326 views1 answer
Ubuntu mysql cannot connect to database server remote
SQL
0 vote335 views1 answer
Shortcut run sql pgadmin
SQL
0 vote307 views1 answer
Postgresql CREATE EXTENSION pgcrypto
SQL
0 vote364 views3 answers
Characters found after end of sql statement
SQL
0 vote362 views1 answer
Sql basic commands
SQL
0 vote350 views2 answers
Coursera spark sql max count
SQL
1 vote316 views1 answer
Postgres convert date to string
SQL
0 vote344 views1 answer
Sql date with year
SQL
0 vote322 views1 answer
Ubuntu connect to mssql database
SQL