SQL substr () function usage

This article introduces how to use the substr () string truncation function in oracle and plsql. If you need it, you can refer to it.

Syntax

The Code is as follows:	Copy code
Substr (string, start_position, [length])

The string is the source string.

Start_position is the extracted position. The first position in the string is always 1.

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

Applies:

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

Instance

The Code is as follows:	Copy code
Substr ('this is a test', 6, 2) wowould return 'is' Substr ('this is a test', 6) wocould return 'is a Test' Substr ('techonthenet ', 1, 4) wocould return 'tech' Substr ('techonthenet ',-3, 3) wocould return 'net' Substr ('techonthenet ',-6, 3) wocould return 'the' Substr ('techonthenet ',-8, 2) wocould return 'on'