Oracle drop sequence if exists

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

2 votes267 views1 answer
Query to check cpu utilization in oracle database
SQL
0 vote267 views1 answer
Group by two columns postgres
SQL
0 vote279 views1 answer
Oracle plsql sleep
SQL
0 vote285 views1 answer
Alter domain sql
SQL
0 vote269 views2 answers
How to get the date from datetime in mysql
SQL
0 vote263 views1 answer
How to combine first and last nae into one columb sql
SQL
0 vote276 views1 answer
Example database query
SQL
2 votes218 views1 answer
Mysql admin u root p password change password
SQL
1 vote236 views1 answer
Truncate table in postgresql and reset id
SQL
20 votes251 views2 answers
Counting in sql
SQL