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 vote266 views1 answer
How to run sql script
SQL
1 vote363 views1 answer
Create new table from old table
SQL
0 vote272 views1 answer
How to connect sql server using ip address in c#
SQL
0 vote282 views1 answer
How to get last client id sql
SQL
0 vote309 views1 answer
Mysql update sum same table
SQL
0 vote313 views1 answer
Cannot truncate a table referenced in a foreign key constraint (`video_clips`.`channel_clips`, CONSTRAINT `clips_fk` FOREIGN KEY (`clip_id`) REFERENCES `video_clips`.`clips` (`id`)) in sql]
SQL
1 vote335 views1 answer
Cannot drop database because it is currently in use
SQL
0 vote334 views1 answer
Can we rollback in sql
SQL
0 vote322 views1 answer
Postgresql heritage
SQL
0 vote317 views1 answer
Recover deleted data from mysql database
SQL