oracle生成流水号的两种方法:
1.SELECT lpad(nvl(to_char(max(T.NO)+1),'000001'),6,'0') FROM TB T
2.select to_char(nvl(max(t.dd_no), 0) + 1, 'fm000000') from TB t
oracle生成流水号的两种方法:
1.SELECT lpad(nvl(to_char(max(T.NO)+1),'000001'),6,'0') FROM TB T
2.select to_char(nvl(max(t.dd_no), 0) + 1, 'fm000000') from TB t