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 vote141 views1 answer
Oracle enable chain
SQL
5 votes158 views2 answers
Mysql create database charset utf8mb4
SQL
1 vote161 views3 answers
Postgresql crete view
SQL
0 vote141 views1 answer
Oracle session statistics
SQL
0 vote204 views1 answer
Mysql update all record removing 2 hours from column
SQL
0 vote138 views1 answer
Sql datediff month
SQL
2 votes139 views1 answer
Datetrunc
SQL
2 votes178 views6 answers
In operator in sql
SQL
0 vote165 views1 answer
Many rows to 1 string mysql
SQL
0 vote125 views1 answer
How to find unique key in sql
SQL