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 vote189 views1 answer
MySQL FIND_IN_SET()
SQL
0 vote216 views1 answer
Sql file in postgres with pgadmin
SQL
6 votes236 views1 answer
How to get the size of the database in postgresql
SQL
0 vote203 views1 answer
Sql server alter table add column tinyint
SQL
0 vote193 views1 answer
How to see password mysql vestacp
SQL
0 vote161 views1 answer
Create duplicate table postgres
SQL
11 votes204 views2 answers
How to import mysql database command line
SQL
0 vote187 views1 answer
How to get n result in sql
SQL
0 vote206 views1 answer
Mysql:5.6 syntax create table
SQL
0 vote212 views1 answer
Rows, INSERT INTO, Returning
SQL