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 vote199 views1 answer
Postgresql alter column nullable
SQL
0 vote205 views1 answer
Database schema for mcqs type exam in sql
SQL
5 votes242 views2 answers
Functions
SQL
27 votes207 views4 answers
Get all tables with column name sql
SQL
26 votes202 views2 answers
What is the sql statement that finds duplicate usernames
SQL
0 vote260 views1 answer
000webhost database values insert
SQL
13 votes200 views6 answers
Current date sql
SQL
3 votes269 views2 answers
Oracle drop column
SQL
6 votes207 views3 answers
Commit in sql
SQL
-1 vote211 views5 answers
Online sql to linq generator
SQL