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 vote290 views1 answer
SQL SELECT-Klausel
SQL
2 votes290 views2 answers
Mysql show table column comments sql
SQL
0 vote284 views1 answer
Insert thai language sql server
SQL
4 votes290 views1 answer
SQL find text in SP
SQL
0 vote288 views1 answer
Sql query to get column names and data types in sql server
SQL
0 vote340 views1 answer
Tsql cte in a transaction
SQL
2 votes283 views1 answer
Add 2 hours to current time in MySQL
SQL
1 vote243 views1 answer
Postgres division by zero
SQL
0 vote299 views1 answer
Query to remove duplicate rows from a table
SQL
2 votes302 views2 answers
Storing timezones in postgres
SQL