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 vote284 views1 answer
T-SQL Retry (deadlock)
SQL
0 vote304 views1 answer
SELECT statement to find the specific cell in database table
SQL
0 vote298 views1 answer
Create table with float datatype in sql server
SQL
-2 votes286 views1 answer
Create trigger syntax
SQL
1 vote281 views1 answer
Psql connect to another database
SQL
1 vote289 views1 answer
Mysql get character set
SQL
0 vote295 views1 answer
Difference between db.query and db.execute
SQL
1 vote246 views1 answer
Oracle boolean to varchar
SQL
0 vote378 views1 answer
Sp help text in postgresql
SQL
11 votes293 views1 answer
Sql insert multiple rows from select
SQL