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

1 vote208 views3 answers
String to int mysql
SQL
2 votes235 views1 answer
Query to check cpu utilization in oracle database
SQL
0 vote249 views1 answer
Offset in postgresql example
SQL
1 vote264 views1 answer
Nvl postgres
SQL
0 vote237 views1 answer
Remove transient options sql wordpress
SQL
0 vote231 views1 answer
Cast as decimal postgresql
SQL
0 vote235 views1 answer
How to insert multiple rows in mysql using laravel
SQL
11 votes252 views1 answer
Ddl view
SQL
0 vote221 views1 answer
Plpgsql if statement
SQL
0 vote235 views1 answer
Populate db from command line postgres
SQL