oracle日期和sequence生成随机ID

insert into mydata.user(id,username) values ( to_char(sysdate,'yyyymmddHH24mmss') || lpad(mydata.seq_user.nextval,12,'0') , '测试用户')

 

没有更多推荐了,返回首页