SUBSTRING SQL PLSQL code example
Example 1: plsql left() function
SUBSTR( "20190601", 0, 6 )
Example 2: ORACLE SQL SUBSTR
SUBSTR(string, :START_POS, :SUBSTR_LENGTH);
SELECT SUBSTR('ABCDEFG',3,4) FROM DUAL;
--OUTPUT: CDEF
SUBSTR( "20190601", 0, 6 )
SUBSTR(string, :START_POS, :SUBSTR_LENGTH);
SELECT SUBSTR('ABCDEFG',3,4) FROM DUAL;
--OUTPUT: CDEF