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 vote319 views1 answer
Mssql check if date is greater than today
SQL
0 vote355 views2 answers
Generate sql trigger through ef migration
SQL
0 vote314 views1 answer
Denormalise SQL command
SQL
0 vote334 views4 answers
Postgresql between month
SQL
2 votes386 views1 answer
Create delete procedure mysql
SQL
1 vote333 views1 answer
SQL Integer devision
SQL
0 vote305 views1 answer
Alter precision
SQL
0 vote387 views1 answer
Sql datum formatieren
SQL
0 vote325 views1 answer
Mysql select field if condition
SQL
1 vote322 views1 answer
Apex select list ORA-20999
SQL