Oracle/PLSQL 中的 substr 函数用于从字符串中提取子串。它接受源字符串、开始位置和可选的长度作为参数。开始位置为1表示从字符串开头提取，负数表示从末尾开始倒数。如果省略长度，则返回整个字符串。当长度为负数时，结果为 NULL。例子展示了不同参数设置下的提取结果。
In Oracle/PLSQL, the substr functions allows you to extract a substring from a string.
Syntax
The syntax for the substr function is:
substr( string, start_position, [ length ] )
string is the source string.
start_position is the position for extraction. The first position in the string is always 1.
length is optional. It is the number of characters to extract. If this parameter is omitted, substr will return the entire string.
Note
If start_position is 0, then substr treats start_position as 1 (ie: the first position in the string).
If start_position is a positive number, then substr starts from the beginning of the string.
If start_position is a negative number, then substr starts from the end of the string and counts backwards.
If length is a negative number, then substr will return a NULL value.
Applies To
- Oracle 11g, Oracle 10g, Oracle 9i, Oracle 8i
For Example
| substr('This is a test', 6, 2) | would return 'is' |
| substr('This is a test', 6) | would return 'is a test' |
| substr('TechOnTheNet', 1, 4) | would return 'Tech' |
| substr('TechOnTheNet', -3, 3) | would return 'Net' |
| substr('TechOnTheNet', -6, 3) | would return 'The' |
| substr('TechOnTheNet', -8, 2) | would return 'On' |
扫一扫
464
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
