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

0 vote293 views1 answer
Sql grant select only
SQL
0 vote322 views1 answer
Check user sql password from command line
SQL
0 vote298 views1 answer
Difference between 2 query results sql server
SQL
2 votes317 views1 answer
Java.lang.arrayindexoutofboundsexception: index 0 out of bounds for length 0
SQL
2 votes310 views1 answer
Sql OR
SQL
0 vote310 views1 answer
Oracle create job if not exists
SQL
0 vote318 views1 answer
Watch mysql command line
SQL
4 votes285 views1 answer
Mysql insert from local csv
SQL
0 vote351 views1 answer
Should I use the datetime or timestamp data type in MySQL?
SQL
0 vote291 views2 answers
What is 1=2 in sql
SQL