http://www.itpub.net/viewthread.php?tid=1153291&extra=&page=2
方法一:
select case when length(str) < 5 then &str else substr(str, 1, length(str) - 5 + 1) end result from t;
方法二:
select reverse(substr(reverse('ssssssghgjknmhloirot'),5)) ff from dual
[@more@]来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/16115580/viewspace-1020946/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/16115580/viewspace-1020946/