Examples
The following example returns several specified substrings of "ABCDEFG":
SELECT SUBSTR(‘ABCDEFG‘,3,4) "Substring"
FROM DUAL;
Substring
---------
CDEF
SELECT SUBSTR(‘ABCDEFG‘,-5,4) "Substring"
FROM DUAL;
Substring
---------
CDEF原文：https://www.cnblogs.com/kakaisgood/p/9071424.html