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

27 votes150 views6 answers
Set password mysql
SQL
3 votes135 views2 answers
Mysql HAVING
SQL
0 vote132 views1 answer
Mysql bash execute sql file
SQL
1 vote135 views1 answer
Table information in sql server
SQL
1 vote148 views1 answer
How to convert number to hours and minutes in oracle sql
SQL
7 votes123 views3 answers
Add primary key to database sql
SQL
6 votes141 views3 answers
Sql select last id
SQL
5 votes135 views1 answer
Oracle drop index if exists
SQL
2 votes137 views1 answer
Mysql Incorrect column specifier for column
SQL
0 vote138 views1 answer
Sqlite3 get data from table c
SQL