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

7 votes269 views3 answers
Sql server check if temp table exists
SQL
1 vote190 views1 answer
Mysql get last insert id
SQL
10 votes217 views2 answers
Linux command line import mysql database
SQL
24 votes252 views6 answers
Sql change table name
SQL
0 vote274 views1 answer
Mysql, how to query the table comments?
SQL
1 vote221 views1 answer
Backup mysql data only
SQL
0 vote222 views1 answer
Sqlite3 pragma foreign keys
SQL
0 vote238 views4 answers
Creating a comment and reply system PHP and MySQL
SQL
11 votes234 views2 answers
Having clause in sql
SQL
7 votes223 views1 answer
Sql server convert string to date
SQL