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

6 votes324 views2 answers
Clear a table in mysql
SQL
1 vote317 views1 answer
Sql server locks
SQL
0 vote343 views1 answer
Load SQLite in Jupyter Notebook together with the access to the file
SQL
0 vote351 views1 answer
Sql query to find percentage of null values in a table
SQL
0 vote320 views1 answer
Mysql find db contarint
SQL
1 vote323 views1 answer
Create new table in SQL from old table with data
SQL
0 vote333 views1 answer
Create bdd mysql
SQL
0 vote317 views1 answer
Character count sql
SQL
0 vote335 views1 answer
Get a list of tables and the primary key
SQL
0 vote345 views1 answer
List in one column mysql
SQL