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

7 votes172 views2 answers
Execute mysql file
SQL
0 vote168 views1 answer
Oracle sqlp update amount / quantity
SQL
15 votes161 views2 answers
How to drop database name in postgresql
SQL
0 vote168 views1 answer
Drop check command
SQL
0 vote177 views1 answer
Postgres declare variable
SQL
0 vote190 views1 answer
Sql cmd no truncate
SQL
0 vote133 views1 answer
Best way to create a temp table with same columns and type as a permanent table
SQL
0 vote189 views1 answer
Insert data from stored procedure into table
SQL
0 vote197 views1 answer
Vs 2019 connect to local mysql database
SQL
1 vote182 views2 answers
Begin transaction in sql
SQL