create sequence XXX_SEQ; select XXX('0000'||xxx_seq.nextval,-6) from dual;---转换成0000格式 转载于:https://www.cnblogs.com/aiwoqu/p/3972863.html