SQL生成序列号

清华大佬耗费三个月吐血整理的几百G的资源,免费分享!....>>>

select id,'Q'||to_char(sysdate,'yymmdd')||substr('00000',0,5-length(id))||id from sys_admin t order by id;