oracle sql drop sequence
DROP SEQUENCE sequence_name;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;Copyright © 2021 Codeinu
Forgot your account's password or having trouble logging into your Account? Don't worry, we'll help you to get back your account. Enter your email address and we'll send you a recovery link to reset your password. If you are experiencing problems resetting your password contact us
