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

12 votes115 views1 answer
Docker run mysql image
SQL
0 vote118 views2 answers
How to drop mili second in sql
SQL
0 vote120 views1 answer
How to install Firebird
SQL
23 votes113 views2 answers
Query to delete a database in mysql
SQL
0 vote123 views1 answer
Sql anywhere create procedure
SQL
-1 vote105 views2 answers
Get day in sql
SQL
1 vote114 views1 answer
Mysql view curren querys
SQL
50 votes175 views4 answers
Sql alter type of column
SQL
0 vote115 views1 answer
A good way of running a SQL query in JDBC using a parameterized statement
SQL
0 vote108 views1 answer
Oracle list proxy users
SQL