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 vote375 views1 answer
Mysql workbench Error Code: 2013. Lost connection to MySQL server during query
SQL
0 vote361 views1 answer
Is there any limit of using joins in single mysql query ?
SQL
1 vote315 views3 answers
Default password of mysql
SQL
0 vote331 views1 answer
Sql offfset
SQL
0 vote372 views1 answer
How to connect to xampp sql server on windows cmd
SQL
0 vote331 views1 answer
Sqlalchemy get ids
SQL
9 votes351 views5 answers
Laravel to sql
SQL
0 vote319 views1 answer
INSERT INTO table using OpenQuery
SQL
0 vote329 views1 answer
Get records in sql according to month name and count
SQL
1 vote333 views1 answer
Get last week data in mysql
SQL