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 vote111 views1 answer
How to get distinct sets of rows using SQL (Oracle)?
SQL
0 vote71 views1 answer
Jooq finding lastest value in table
SQL
0 vote111 views1 answer
Oracle grant create job
SQL
0 vote126 views1 answer
R write csv without index
SQL
0 vote132 views3 answers
Postgres trim string
SQL
0 vote121 views1 answer
Mysql zerofill
SQL
1 vote124 views1 answer
Wordpress change http to https phpmyadmin
SQL
0 vote111 views1 answer
Illuminate\Database\QueryException SQLSTATE[HY000] [2054] The server requested authentication method unknown to the client (SQL: select * from information_schema.tables where table_schema = blog and table_name = migrations and table_type = 'BASE TABL
SQL
0 vote114 views1 answer
Check if table exists oracle
SQL
12 votes109 views3 answers
Duplicate a column in sql
SQL