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

7 votes185 views3 answers
Sql get last inserted row
SQL
1 vote236 views1 answer
Default
SQL
0 vote206 views2 answers
Mysql insert into multiple tables
SQL
0 vote194 views1 answer
Timestamp(0) postgresql
SQL
4 votes183 views1 answer
Oracle table statistics last analyzed
SQL
-1 vote250 views1 answer
Mysql coalesce
SQL
0 vote179 views1 answer
LoadError: cannot load such file -- mysql2/2.7/mysql2
SQL
0 vote191 views1 answer
Mysql sql.gz
SQL
0 vote225 views1 answer
Enable outgoing remote MySQL access
SQL
0 vote198 views1 answer
Select even number id data from table
SQL