SQL generation serial number

Use the function to generate id-bit auto-increment sequence number rules for custom Oracleselectid, Q | to_char (sysdate, yymmdd) | substr (00000,0, 5-length (id )) | idfromsys_admintorderbyid;

Use the function to generate id-bit auto-increment sequence number rules for custom Oracle select id, 'q' | to_char (sysdate, 'yymmdd') | substr ('123 ', 0,5-length (id) | id from sys_admin t order by id;

Generate serial numbers using functions

Id-bit auto-growth sequence

Custom numbering rules
Oracle

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