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

0 vote164 views1 answer
What is the difference between now() and current_date()?
SQL
0 vote164 views2 answers
Csv into data postgres
SQL
6 votes191 views1 answer
T-sql test if table exists
SQL
2 votes259 views2 answers
Set value to null sql
SQL
6 votes173 views1 answer
Oracle trigger after connect
SQL
1 vote167 views1 answer
How to install mysql 8.0 windows service
SQL
0 vote169 views1 answer
Alasql delete column
SQL
1 vote180 views1 answer
SQL date part only of datetime
SQL
1 vote191 views3 answers
Connection string mysql
SQL
6 votes181 views2 answers
Sql display max value
SQL