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

0 vote324 views1 answer
Replace multiple string in query sql
SQL
1 vote298 views1 answer
Enable mysql slow query log
SQL
8 votes360 views4 answers
Reset SQL auto increment
SQL
13 votes350 views1 answer
Sql join 3 tables on id
SQL
8 votes372 views2 answers
Mysql grant all privileges to user from any host
SQL
0 vote344 views1 answer
SQL authentication error
SQL
0 vote325 views1 answer
Mysqli_real_connect(): (28000/1045): Access denied for user 'u0738423'@'www8.aname.net' (using password: YES)
SQL
0 vote357 views1 answer
Csv to sqlite python
SQL
0 vote355 views1 answer
Sql date between one week
SQL
0 vote376 views2 answers
Mysql insert into multiple tables
SQL