SUBSTR()

Syntax

SUBSTR( <characterexpression>, <startposition> [, <Lengthofcharacterexpression> ] )

Example

SELECT SUBSTR('OracleMine', 2,3) FROM dual;