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

1 vote325 views1 answer
Sql server: query to find out all the places where the table is used
SQL
0 vote307 views1 answer
Psql use query result convert Decimal python numpy psycopg2
SQL
0 vote325 views1 answer
Sql select lowest value row
SQL
0 vote321 views1 answer
Mysql join only one column
SQL
0 vote306 views1 answer
MySql get primary keys of table
SQL
4 votes317 views1 answer
Add constraint fk
SQL
0 vote319 views1 answer
Kill a pid redshift
SQL
6 votes324 views2 answers
Postgresql restore from dump
SQL
0 vote323 views1 answer
How to select a row in sql
SQL
0 vote304 views1 answer
Sql remove first character from string
SQL