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

4 votes231 views1 answer
Create table if not exist in sqlite
SQL
2 votes224 views2 answers
Postgres set user as superuser
SQL
3 votes253 views2 answers
Order by postgresql
SQL
0 vote235 views1 answer
Create table in dbms cmds
SQL
-1 vote254 views1 answer
Phinehas Psalm 106
SQL
2 votes248 views1 answer
Oracle to_char number format percentage
SQL
3 votes249 views2 answers
Oracle privileges users
SQL
2 votes291 views1 answer
Sql compare strings
SQL
-1 vote252 views1 answer
Create view in mysql workbench
SQL
0 vote243 views2 answers
How to create a table from another table in sql derby
SQL