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 votes310 views1 answer
Sqlite show table indexes
SQL
0 vote316 views1 answer
Insufficient memory to excute the sql query
SQL
0 vote336 views1 answer
Distinct data types in a table sql query
SQL
0 vote322 views1 answer
Price-colour
SQL
1 vote314 views1 answer
Increase date by one day in sql oracle
SQL
0 vote344 views1 answer
T-SQL Create Trigger
SQL
0 vote330 views1 answer
How to drop a column in mysql laravel stackoverflow
SQL
0 vote331 views1 answer
Mysql set column equal to another automatic
SQL
0 vote340 views1 answer
Insert or update sql query
SQL
0 vote350 views1 answer
Mariadb datetime change to microseconds
SQL