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 vote176 views1 answer
Tsql cte in a transaction
SQL
9 votes136 views2 answers
Sql server check table exists
SQL
0 vote177 views1 answer
Mysql relationships between tables
SQL
0 vote143 views1 answer
Heidisql check how much space a row
SQL
0 vote147 views1 answer
Get a list of tables and the primary key
SQL
0 vote162 views1 answer
Select all same column value in sql
SQL
0 vote152 views1 answer
Create tables from xsd to sql server database c#
SQL
3 votes143 views4 answers
Truncate syntax in sql
SQL
4 votes126 views1 answer
Invalid reference to FROM-clause entry for table "unidades
SQL
1 vote141 views3 answers
Sql select only time from datetime
SQL