oracle sql lef 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