Simple usage of Oracle's SUBSTR function

substr (string, intercept start position, intercept length) //Returns the truncated string (containing the start position)

Select substr (' HelloWorld ', 0,3) value from dual; --The returned result is Helselect substr (' HelloWorld ', 1,3) value from dual; --The returned result is Hel, 0 and 1 are both represented from the first character or intercept select substr (' HelloWorld ', 6,5) value from dual; --The returned result is Worldselect substr (' HelloWorld ', -3,3) value from dual; --The returned result is a Rld negative number (-I) indicating that the intercept starts at the right end of the string, and the first character in the left

Itmyhome

Simple usage of Oracle's SUBSTR function