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

12 votes363 views6 answers
How to install sqlite3 in python
SQL
0 vote322 views1 answer
Mysql shell set time_zone
SQL
3 votes360 views3 answers
Postgresql random number
SQL
0 vote332 views1 answer
How to input data as id in database sql c#
SQL
4 votes352 views2 answers
Float postgres
SQL
6 votes320 views2 answers
Mysql check auto increment value
SQL
0 vote345 views1 answer
Excel vba import data to sql server
SQL
0 vote345 views1 answer
SQL division of an integer by another integer get float CAST
SQL
0 vote339 views1 answer
Teller stamp , bmo , PDF
SQL
0 vote343 views1 answer
Compare subqueries oracle
SQL