Drop sequence

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

2 votes148 views1 answer
Import large .sql files into lampp
SQL
0 vote191 views1 answer
Oracle temporary table
SQL
24 votes154 views4 answers
Mysql datetime
SQL
1 vote149 views1 answer
Show structure of table in sql
SQL
0 vote137 views2 answers
Add colum in sql
SQL
0 vote137 views1 answer
Postgres type equivalent to timespan c#
SQL
-1 vote134 views3 answers
Create temp table in sql
SQL
2 votes144 views1 answer
Copy all values of a column to another column in sql in same table
SQL
2 votes164 views3 answers
Postgres json to string
SQL
1 vote137 views1 answer
SQL date part only of datetime
SQL