select substr(‘12345’,greatest( -位数,-length(‘12345’)),位数) from dual
(ps:位数是数字)
发布者:全栈程序员-站长,转载请注明出处:https://javaforall.net/220770.html原文链接:https://javaforall.net
oracle 截取字符串最后几位selectsubstr 12345 greatest 位数 length 12345 位数 fromdual nbsp ps 位数是数字
select substr(‘12345’,greatest( -位数,-length(‘12345’)),位数) from dual
(ps:位数是数字)
发布者:全栈程序员-站长,转载请注明出处:https://javaforall.net/220770.html原文链接:https://javaforall.net