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

0 vote40 views1 answer
Get records in sql according to month name and count
SQL
0 vote43 views1 answer
Oracle for loop on list
SQL
0 vote49 views1 answer
Bash block size ls /var/lib/mysql
SQL
15 votes52 views6 answers
Laravel db transaction
SQL
-1 vote45 views1 answer
Brisanje dupliranih konatakata
SQL
0 vote51 views1 answer
Sql check if column exists
SQL
0 vote51 views2 answers
Auto increment column in mysql query results
SQL
3 votes44 views2 answers
Oracle drop column
SQL
0 vote49 views1 answer
Executescalar in sql server
SQL
0 vote48 views1 answer
Compare subqueries oracle
SQL