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 vote212 views1 answer
Sql grant select only
SQL
1 vote228 views3 answers
Update from select sqlite
SQL
1 vote217 views1 answer
$query = mysqli_query($con, $sql); while ($row = mysqli_fetch_array($query))
SQL
0 vote212 views1 answer
Get employees if not contains in sql
SQL
0 vote246 views1 answer
Postgresql custom order by
SQL
3 votes235 views2 answers
SqlMessage: "Host '192.168.64.1' is not allowed to connect to this MariaDB server
SQL
22 votes228 views4 answers
Mysql reset auto increment id
SQL
17 votes219 views2 answers
Mysql date to string
SQL
0 vote230 views1 answer
SAP Return
SQL
4 votes228 views2 answers
Oracle last day of month
SQL