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 vote129 views1 answer
Mysqli or pdo
SQL
0 vote164 views1 answer
Oracle search in date columns
SQL
0 vote181 views2 answers
Generate sql trigger through ef migration
SQL
2 votes146 views2 answers
Sqlite_busy: database is locked
SQL
4 votes166 views1 answer
Mysql copy table with new name
SQL
0 vote117 views1 answer
Check if due date is less than todays date sql
SQL
0 vote154 views1 answer
If null don't update
SQL
0 vote177 views1 answer
Sqlite insert or update
SQL
0 vote150 views1 answer
Mysql events not work
SQL
0 vote182 views1 answer
Mysql default tls v1.3 ciphersuites
SQL