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 vote253 views1 answer
Left join vs inner join performance
SQL
0 vote230 views1 answer
Sql server select ignore dupplicates
SQL
11 votes244 views1 answer
Oracle insert from select
SQL
0 vote246 views1 answer
Exectuer myssql .sql
SQL
0 vote235 views1 answer
Test connection to sql server
SQL
-1 vote290 views5 answers
Left join sql
SQL
3 votes242 views1 answer
How to find names includes in sql
SQL
1 vote243 views1 answer
Mysql current time
SQL
0 vote235 views1 answer
Online sql testing tool
SQL
0 vote254 views1 answer
Sqlite löschen einer tabelle
SQL