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

3 votes295 views1 answer
Sql is not like
SQL
0 vote301 views1 answer
Left join vs inner join performance
SQL
4 votes284 views2 answers
Oracle default date format
SQL
1 vote345 views1 answer
OSError: mysql_config not found
SQL
1 vote337 views1 answer
Import sql file from laravel
SQL
0 vote286 views1 answer
Commit transaction sql
SQL
3 votes284 views2 answers
Plsql print
SQL
0 vote314 views1 answer
Mysql collation portugues brasil
SQL
0 vote279 views1 answer
Get server date mysql
SQL
0 vote277 views1 answer
No suitable driver found for sqlite
SQL