oracle 排序字段自增长

insert id="insertGoodsDescription" parameterClass="goodsDescription" > <selectKey resultClass="int" keyProperty="serviceDescriptionId" > SELECT goods_description_SEQ.nextval AS service_description_id from dual </selectKey> insert into product_service_description ( service_description_id, label_name, label_icon, label_description, sort_num, product_id, is_default, is_delete, ADD_TIME, ADD_USER_ID, EDIT_TIME, EDIT_USER_ID) values ( #serviceDescriptionId#, #labelName#, #labelIcon#, #labelDescription#, nvl (#sortNum#, ( SELECT MAX(sort_num) + 1 FROM product_service_description) ), <!--#sortNum#,--> #productId#, #isDefault#, ‘N‘, #addTime#, #addUserId#, #editTime#, #editUserId# ) </insert>

<span style="color: #808080;"><</span>!<span style="color: #008080;">--</span><span style="color: #008080;"> 添加微信团活动 --></span>
    
    <span style="color: #808080;"><</span><span style="color: #0000ff;">insert</span> id<span style="color: #808080;">=</span>"<span style="color: #0000ff;">save</span>" parameterType<span style="color: #808080;">=</span>"WeixinActivity"<span style="color: #808080;">></span>
   
    <span style="color: #0000ff;">INSERT</span> <span style="color: #0000ff;">INTO</span><span style="color: #000000;">  weixin_activity
    (
     WEIXIN_NAME,
     BANNER_IMG_URL,
     START_TIME,
     END_TIME , 
     GROUP_PRICE,
     DISCOUNT_LAB,
     MINIMUM_JOIN_MEMBER_NUM,
     ORDER_BY,
     IS_STATUS,
     BEGIN_WAIT_TIME,
     ADD_USER_ID,
     EDIT_TIME,
     IS_DELETE,
     ADD_TIME,
     EDIT_USER_ID
     ) </span><span style="color: #0000ff;">values</span><span style="color: #000000;">
    ( 
    #{weixinName},
    #{bannerImgUrl},
    #{startTime},
    #{endTime},
    #{groupPrice},
    #{discountLab},
    #{minimumJoinMemberNum},
    IFNULL(#{sortBy},  (
        </span><span style="color: #0000ff;">SELECT</span><span style="color: #000000;"> id
        </span><span style="color: #0000ff;">FROM</span><span style="color: #000000;"> (
        </span><span style="color: #0000ff;">SELECT</span> <span style="color: #ff00ff;">MAX</span>(order_by) <span style="color: #808080;">+</span> <span style="color: #800000; font-weight: bold;">1</span> <span style="color: #0000ff;">AS</span><span style="color: #000000;"> id
        </span><span style="color: #0000ff;">FROM</span><span style="color: #000000;"> weixin_activity) t)),
    
    
</span><span style="color: #808080;"><</span>!<span style="color: #008080;">--</span><span style="color: #008080;">         (select id from   --></span>
<span style="color: #808080;"><</span>!<span style="color: #008080;">--</span><span style="color: #008080;">    (SELECT MAX(order_by) + 1 as id FROM weixin_activity) t), --></span>
<span style="color: #000000;">   
    #{isStatus},
    #{beginWaitTime},
    #{addUserId},
    #{editTime},
    </span><span style="color: #ff0000;">‘</span><span style="color: #ff0000;">N</span><span style="color: #ff0000;">‘</span><span style="color: #000000;">,
    #{addTime},
    #{editUserId}
    )
  </span><span style="color: #808080;"></</span><span style="color: #0000ff;">insert</span><span style="color: #808080;">></span>

 

oracle 排序字段自增长

标签：iss   sde   code   bsp   活动   sel   rom   nextval   sort