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

2 votes377 views5 answers
Install postgresql 10 centos 7
SQL
1 vote345 views2 answers
Mysql join two tables
SQL
0 vote325 views1 answer
Sql from null to not null
SQL
1 vote348 views1 answer
Import sql file mysql commadn line
SQL
3 votes356 views2 answers
WhereIn SQL
SQL
0 vote334 views2 answers
Mysql multiply
SQL
4 votes329 views1 answer
Oracle show error line number
SQL
0 vote370 views1 answer
How to Remove milliseconds from Date time
SQL
0 vote361 views1 answer
Power bi find all ids not in other tables
SQL
0 vote426 views1 answer
Sql query inline if
SQL