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 votes160 views2 answers
Function in sql
SQL
2 votes219 views3 answers
Row number mssql
SQL
1 vote166 views2 answers
Drop function in sql
SQL
3 votes184 views2 answers
Having in mysql
SQL
-1 vote162 views2 answers
Postgres autoincrement primary key
SQL
0 vote191 views1 answer
Sql query use select name inside where clause
SQL
1 vote169 views1 answer
Sometimes i cant edit sql developer
SQL
0 vote239 views1 answer
Mysql readable output
SQL
13 votes162 views2 answers
Oracle select into and inner join
SQL
2 votes197 views1 answer
Oracle log files
SQL