Oracle sql drop sequence

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 vote241 views1 answer
Alling a function from PL/SQL in a select statement in ORACLE
SQL
0 vote246 views1 answer
Sql convert float to string
SQL
0 vote281 views2 answers
How to prevent sql injection in java
SQL
0 vote203 views1 answer
Sql get count without group by
SQL
1 vote199 views1 answer
Caused by: java.lang.IllegalStateException: Cannot load driver class: com.mysql.jdbc.Driver
SQL
1 vote205 views1 answer
Mysql list bigger table
SQL
0 vote196 views1 answer
Oracle sql procedure return value
SQL
0 vote153 views1 answer
Mysqli or pdo
SQL
0 vote212 views1 answer
List mysql tables and views
SQL
15 votes207 views2 answers
Select where duplicate mysql
SQL