select substr('0000000000' || '36495',-10) from dual 转载于:https://my.oschina.net/u/3795289/blog/2873706