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