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 vote385 views1 answer
Mysql vs sql server performance benchmark
SQL
0 vote333 views1 answer
Mql5 list all available symbols
SQL
57 votes547 views6 answers
Sql alter table
SQL
1 vote348 views1 answer
Postgres convert date to string
SQL
1 vote523 views1 answer
Postgres upgrade to superuser
SQL
0 vote376 views1 answer
Find the names of sailors who have reserved at least one boat
SQL
-1 vote363 views2 answers
Postgresql get last 10 records
SQL
5 votes324 views1 answer
Oracle list packages
SQL
0 vote343 views1 answer
Setval postgres example table id
SQL
0 vote406 views1 answer
Mysql backup query
SQL