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

1 vote146 views1 answer
How to show index type in postgresql
SQL
0 vote133 views1 answer
Print mysql
SQL
0 vote124 views1 answer
Sql string length postgresql
SQL
-1 vote84 views1 answer
How to create script to connect to oracle database and run query
SQL
4 votes121 views3 answers
Copy table postgres
SQL
0 vote217 views1 answer
How to find the most occuring in SQL
SQL
0 vote189 views1 answer
Sql ssrs
SQL
0 vote133 views1 answer
Oracle enable chain
SQL
2 votes126 views2 answers
Select multiple tables mysql
SQL
1 vote146 views1 answer
Write a query to create an empty table from an existing table?
SQL