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 vote393 views1 answer
Pl sql join 3 tables
SQL
0 vote368 views1 answer
How to check database engine in mysql
SQL
1 vote344 views1 answer
Drush sql-dump
SQL
0 vote332 views1 answer
Sql bild in function
SQL
5 votes364 views1 answer
Purge undo tablespace usage
SQL
0 vote373 views1 answer
How to get column name in db from an sqlalchemy attribute model
SQL
0 vote325 views1 answer
Mysql default uuid
SQL
1 vote333 views1 answer
Create index concurrently postgres
SQL
5 votes394 views2 answers
Add days in oracle sql
SQL
14 votes346 views3 answers
Alter foreign key
SQL