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

5 votes372 views5 answers
Sqlite install python
SQL
14 votes443 views1 answer
How to export db from mysql
SQL
0 vote499 views1 answer
Postgresql powershell query
SQL
1 vote361 views1 answer
Oracle user last connection date
SQL
1 vote391 views1 answer
Update from table tsql
SQL
0 vote380 views1 answer
Execute sql stored procedure in powershell
SQL
1 vote374 views1 answer
How to see which columns are indexxed mysql
SQL
-1 vote349 views1 answer
Mysql extract days
SQL
0 vote354 views1 answer
Change default schema sql server
SQL
0 vote450 views1 answer
Scheduled mysql database backup in linux
SQL