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

10 votes198 views1 answer
Query to find object dependencies in oracle
SQL
0 vote185 views1 answer
Fetch second word from a string in ms sql
SQL
0 vote190 views1 answer
Flask sqlalchemy update row
SQL
3 votes318 views4 answers
Sql interview questions
SQL
20 votes189 views5 answers
Sql show tables
SQL
2 votes197 views2 answers
Mysqli_real_connect(): The server requested authentication method unknown to the client [caching_sha2_password]
SQL
0 vote258 views1 answer
IS THEre any difference between using default and := in plsql
SQL
0 vote209 views1 answer
Pass array parameter to stored procedure c#
SQL
0 vote210 views2 answers
How to login to mysql as normal user in ubuntu
SQL
0 vote199 views1 answer
Bus source and destination equal to destination and source of another by sql query
SQL