oracle日期+sequence生成ID

 select (select to_char(sysdate,'yyyyMMddHH24miss') from dual)||lpad(用户.sequence名.nextval,10,'0') as id

from dual

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