Oracle PL/SQL Substr Function

The Substr function allows you to extract a substring from a string.

The Substr Function syntax:

substr( string, start_position, [ length ] )

Example:

select substr('Report is ready', 8, 2) from dual;
 
would return 'is'


select substr('Report is ready', 8) from dual;

would return 'is ready'


select substr('OracleForms9i', 1, 6) from dual;

would return 'Oracle'


select substr('OracleForms9i', -7, 3) from dual;

would return 'For'


select substr('OracleForms9i', -2, 2) from dual;

would return '9i'