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;

Similar codes

0 vote388 views1 answer
Sql express database size limit
SQL
3 votes361 views1 answer
Créer une table sql
SQL
7 votes382 views1 answer
Xampp reset mysql
SQL
23 votes357 views3 answers
Mysqldump
SQL
5 votes373 views3 answers
Mysql update field from one table to another
SQL
0 vote326 views1 answer
Generate sequence number in sql server
SQL
0 vote348 views1 answer
Output table plsql
SQL
0 vote361 views1 answer
Rollback to name in sql
SQL
3 votes388 views2 answers
Sql add year to date
SQL
13 votes292 views2 answers
Oracle all source
SQL