Oracle sql drop sequence

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

1 vote132 views2 answers
T sql get foreign key
SQL
1 vote153 views3 answers
Drop unique key constraint in sql server
SQL
2 votes147 views1 answer
Mysql sysdate - 1 day
SQL
0 vote195 views1 answer
Postgresql find biggest table
SQL
1 vote163 views2 answers
Setval max id postgresql sequence
SQL
0 vote146 views1 answer
Longtext sql
SQL
2 votes108 views1 answer
Sql select min value from multiple columns
SQL
2 votes156 views1 answer
Query any digits record
SQL
13 votes152 views3 answers
Change data type postgresql
SQL
2 votes219 views2 answers
Mysql compare datetime to another datetime
SQL