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

3 votes113 views4 answers
Mysql delete duplicate rows
SQL
0 vote142 views1 answer
Dump only schema
SQL
0 vote168 views1 answer
Plpgsql if statement
SQL
0 vote162 views1 answer
Rows, INSERT INTO, Returning
SQL
1 vote158 views1 answer
Tsql update datetime
SQL
3 votes150 views2 answers
Oracle synonym
SQL
0 vote163 views2 answers
Change database postgres
SQL
0 vote191 views1 answer
Mysl like insert a variable
SQL
0 vote194 views4 answers
Rownum in sql
SQL
1 vote265 views1 answer
How to select department from table
SQL