SQL substr () function usage details

Grammar

The code is as follows	Copy Code
substr (String, start_position, [length])

The string is the source string.

Start_position is the location of the extraction. The first position in the string is always 1.

Length is optional. It is the number of characters extracted. If this argument is omitted, SUBSTR returns the entire string.

Applies To:

The code is as follows	Copy Code
Oracle 8i, Oracle 9i, Oracle 10g, Oracle 11g

Instance

code is as follows	copy code
substr (' This is a test ', 6, 2 "would return ' was ' substr (' This is a test ', 6) would return ' is a test ' substr (' Techonthen Et ', 1, 4 would return ' Tech ' substr (' techonthenet ', -3, 3) would return ' Net ' substr (' techonthenet ',-6, 3) wo Uld return ' the ' substr (' techonthenet ',-8, 2) would return ' on '