Oracle 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;

Oracle sql drop sequence

DROP SEQUENCE sequence_name;

Similar codes

0 vote108 views1 answer
Oracle date winter time
SQL
1 vote121 views1 answer
Postgres cast as currency format
SQL
0 vote119 views1 answer
SQLSTATE[42S02]: Base table or view not found: 1146 Tabl
SQL
0 vote113 views1 answer
Less mysql display
SQL
0 vote92 views1 answer
Sql cross apply vs join
SQL
0 vote104 views1 answer
Sql inserted
SQL
0 vote109 views1 answer
Mariadb alter table add column if not exists example
SQL
2 votes92 views1 answer
Mysql list users on ubuntu
SQL
2 votes134 views1 answer
Search query in mysql
SQL
18 votes60 views2 answers
How to get all the tables displayed in oracle
SQL