1.select to_char(nvl(max(to_number(mcode)),0)+1) mcode,mdirname from T_MATERIAL_INFO
group by mdirname
Oracle最大值加1
最新推荐文章于 2023-01-17 10:42:21 发布
1.select to_char(nvl(max(to_number(mcode)),0)+1) mcode,mdirname from T_MATERIAL_INFO
group by mdirname