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

2 votes208 views1 answer
Sql missing records from another table
SQL
4 votes150 views1 answer
Mysql timestamp in laravel migration
SQL
0 vote163 views1 answer
Mysql default tls v1.3 ciphersuites
SQL
18 votes150 views4 answers
Uninstall mysql ubuntu 18.04
SQL
1 vote173 views2 answers
Mysql extract number from string
SQL
1 vote185 views2 answers
Mysql add column tinyint default 0
SQL
3 votes178 views2 answers
MySQL query to get column names
SQL
0 vote197 views1 answer
Mysql equivalent decode oracle
SQL
0 vote168 views1 answer
Mysql cast null to string
SQL
0 vote160 views2 answers
Sql searching via key word
SQL