oracle substr SUBSTR( string, start_position [, length ] ) Parameters or Arguments stringThe source string.start_positionThe starting position for extraction. The first position in the string is always 1.