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

1 vote321 views1 answer
Moodle query item quiz
SQL
1 vote312 views2 answers
Sql select only first occurrence
SQL
0 vote323 views1 answer
After kill process Failed to start mysqld.service: Unit mysqld.service not found.
SQL
0 vote328 views1 answer
Find how many tables in database sql query
SQL
0 vote304 views1 answer
How to get all values in a table mysql in c#
SQL
3 votes338 views5 answers
Duplicate table sql
SQL
2 votes351 views3 answers
How to check current user in mySQL
SQL
0 vote320 views1 answer
Sql server select value large text
SQL
3 votes316 views4 answers
Show databases in sql server
SQL
6 votes316 views4 answers
Remove spaces sql server
SQL