JavaEar 专注于收集分享传播有价值的技术资料

1个回答

    最佳答案
  1. From here:

    'select MSG_MESSAGE_SEQUENCE.nextval from dual' INTO l_val;
    
    execute immediate
    'alter sequence ' || p_seq_name || ' increment by 97 - ' || l_val || ' minvalue 97';