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 vote142 views1 answer
Test the postgresql db connection
SQL
0 vote107 views1 answer
Sql select rows with simlar names
SQL
1 vote163 views1 answer
Mysql update inner
SQL
0 vote158 views1 answer
Show table structure mysql console
SQL
1 vote188 views1 answer
How to check all scheduled jobs in oracle
SQL
0 vote129 views1 answer
Calculate date and convert to yearsmysql
SQL
1 vote140 views1 answer
Mysql check table exists
SQL
0 vote155 views4 answers
Open mysql port bitnami tomact
SQL
0 vote155 views1 answer
#1231 - Variable 'sql_mode' can't be set to the value of 'NULL'
SQL
0 vote146 views1 answer
Vbscript connect mssql
SQL