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

3 votes168 views2 answers
@sqlresultsetmapping
SQL
0 vote84 views1 answer
Sql truncate table referencing itself
SQL
1 vote124 views1 answer
How to open closed port mysql in ubuntu
SQL
7 votes140 views6 answers
Group_concat in mysql
SQL
5 votes132 views1 answer
Ascending order and where in sql
SQL
50 votes219 views6 answers
Install mysql on ubuntu
SQL
1 vote137 views1 answer
Select 2 rows in sql
SQL
8 votes136 views2 answers
Safe update mode in mysql
SQL
3 votes120 views2 answers
Laravel tosql with bindings
SQL
0 vote139 views2 answers
SQL Server log file truncate - Source :NAYCode.com
SQL