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

8 votes110 views1 answer
Oracle add months to sysdate
SQL
2 votes163 views2 answers
Set value to null sql
SQL
0 vote107 views1 answer
An error occurred while installing mysql2 (0.5.3)
SQL
2 votes103 views1 answer
Mysql increment value by 1 in update
SQL
0 vote122 views1 answer
Unique element in sql
SQL
0 vote83 views2 answers
How to combine two sql queries in one result
SQL
1 vote110 views1 answer
Show all event schedular on mysql
SQL
1 vote106 views1 answer
Sqlite check if row exists
SQL
0 vote112 views1 answer
What is SQL data store?
SQL
0 vote104 views1 answer
Postgres call view
SQL