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 vote139 views1 answer
Get current date in pyspark sql
SQL
6 votes131 views2 answers
Sql sequence
SQL
0 vote133 views1 answer
Format the money fied with comma in international system using sql
SQL
42 votes184 views6 answers
Sql query duplicate rows
SQL
0 vote112 views1 answer
Remove default constraint sql server
SQL
4 votes120 views1 answer
Mac install mysql
SQL
0 vote106 views1 answer
Drush SQLSTATE[HY000] [2002] No such file or directory
SQL
1 vote118 views1 answer
Import database from a file using mysql commandline
SQL
9 votes140 views6 answers
Oracle substring
SQL
0 vote128 views1 answer
Renommer base sql
SQL