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 vote159 views1 answer
Postgresql get diff between two dates in Months
SQL
0 vote145 views1 answer
Postrgres trunc
SQL
0 vote180 views1 answer
Mysql dump for selected row
SQL
1 vote166 views1 answer
Decalre temp table sql
SQL
0 vote151 views1 answer
Mysql where don't have string
SQL
0 vote191 views2 answers
Suse Linux restart MySQL
SQL
0 vote166 views1 answer
Typical max-connect-errors mysql
SQL
0 vote157 views1 answer
Selecting duplicates
SQL
0 vote242 views1 answer
Python mysql check if database exists
SQL
0 vote169 views1 answer
SQLSTATE[01000]: Warning: 1265 Data truncated for column 'job_type' at row 1 (SQL: insert into
SQL