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 vote194 views2 answers
Get table column names sql laravel
SQL
0 vote205 views1 answer
Sql select lowest value row
SQL
0 vote190 views1 answer
Bidirectional outer join sql
SQL
0 vote200 views2 answers
Oracle create tablespace autoextend
SQL
32 votes226 views6 answers
Rename column mysql
SQL
2 votes177 views1 answer
Mysql find tables with name
SQL
21 votes155 views7 answers
Table drop if exist sql server
SQL
2 votes182 views1 answer
Postgresql add entry to table
SQL
2 votes182 views2 answers
Select multiple tables mysql
SQL
1 vote260 views1 answer
Mysql connect command
SQL