app-dono-modulos/migrations/20260407140549_seq_flash_perdas.sql

-- +goose Up
DECLARE
    v_count NUMBER;
BEGIN
    SELECT COUNT(*) INTO v_count
      FROM USER_SEQUENCES
     WHERE SEQUENCE_NAME = 'SEQ_FLASH_PERDAS';

    IF v_count = 0 THEN
        EXECUTE IMMEDIATE 'CREATE SEQUENCE SEQ_FLASH_PERDAS
            START WITH 1 INCREMENT BY 1 NOCACHE NOCYCLE';
    END IF;
END;

-- +goose Down
DECLARE
    v_count NUMBER;
BEGIN
    SELECT COUNT(*) INTO v_count
      FROM USER_SEQUENCES
     WHERE SEQUENCE_NAME = 'SEQ_FLASH_PERDAS';

    IF v_count > 0 THEN
        EXECUTE IMMEDIATE 'DROP SEQUENCE SEQ_FLASH_PERDAS';
    END IF;
END;