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

5 votes262 views4 answers
Sql check
SQL
5 votes272 views3 answers
Select tables from mysql database
SQL
3 votes256 views2 answers
Mysql add 2 hours
SQL
3 votes269 views2 answers
Postgresql remove not null constraint
SQL
0 vote267 views1 answer
Mysql find the row ites of the hoghest value at on column
SQL
0 vote278 views1 answer
Configure MYSQL to run on another port number, other than the default port 3306 ubuntu linux
SQL
0 vote262 views2 answers
Pg_restore: error: input file appears to be a text format dump. Please use psql.
SQL
2 votes316 views1 answer
Oracle run_duration to number
SQL
0 vote291 views1 answer
Oracle sql developer closed connection
SQL
1 vote284 views1 answer
Mysql datetime with timezone offset
SQL