check sub string from last in pl sql code example

Example 1: plsql left() function

SUBSTR( "20190601", 0, 6 )

Example 2: plsql substr

SUBSTR( string, start_position [, length ] )