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

0 vote148 views1 answer
Proc sql not in working
SQL
1 vote151 views2 answers
Mysql limit offset
SQL
4 votes131 views1 answer
Oracle session date format
SQL
0 vote157 views2 answers
Mysql missin expression near on
SQL
1 vote196 views1 answer
Postgres set sequence value to max id
SQL
1 vote164 views1 answer
Psql connect
SQL
0 vote144 views5 answers
ABC TO FLEX BATTLE IM POOR
SQL
4 votes273 views1 answer
Oracle table statistics
SQL
0 vote159 views1 answer
Least spark sql
SQL
4 votes156 views1 answer
Sql quote in string
SQL