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

-1 vote116 views1 answer
Sql oracle take only last results
SQL
3 votes123 views1 answer
Oracle list user grants
SQL
6 votes111 views1 answer
Phpmyadmin password root
SQL
0 vote105 views1 answer
2020 new year
SQL
6 votes122 views3 answers
Error Code: 1055. Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'mydb.term.year' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
SQL
5 votes115 views2 answers
Ranking functions in sql
SQL
0 vote104 views1 answer
Postgresql regular expression special characters
SQL
10 votes127 views4 answers
Sql server pagination
SQL
10 votes137 views2 answers
Select nextval from sequence oracle
SQL
2 votes117 views2 answers
Change mysql password from command line
SQL