Oracle sql drop sequence

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

0 vote119 views1 answer
Ubuntu stop mysql from starting on boot
SQL
1 vote124 views2 answers
Maximum number of tables in mysql
SQL
0 vote117 views1 answer
Which lock mode is not available in sql
SQL
0 vote123 views1 answer
Install sql server windows 10
SQL
13 votes113 views2 answers
Sql count distinct group by
SQL
0 vote141 views2 answers
Wordpress change url after migration mysql query
SQL
0 vote124 views1 answer
Sparql list all graphs
SQL
2 votes164 views2 answers
How to DROP a table in mysql
SQL
2 votes73 views4 answers
Mysql change database character set to utf8mb4
SQL
2 votes120 views1 answer
Compare date in sql
SQL