substring function in oracle sql example
Example 1: plsql substr
SUBSTR( string, start_position [, length ] )Example 2: ORACLE SQL SUBSTR
SUBSTR(string, :START_POS, :SUBSTR_LENGTH);
SELECT SUBSTR('ABCDEFG',3,4) FROM DUAL;
--OUTPUT: CDEFSUBSTR( string, start_position [, length ] )SUBSTR(string, :START_POS, :SUBSTR_LENGTH);
SELECT SUBSTR('ABCDEFG',3,4) FROM DUAL;
--OUTPUT: CDEF