substr函数：
取得字符串中指定起始位置和长度的字符串 substr( string, start_position,
[
length
]
)
如:
substr(
'
This is a test
'
,
6
,
2
) would
return
'
is
'
substr(
'
This is a test
'
,
6
) would
return
'
is a test
'
substr(
'
TechOnTheNet
'
,
-
3
,
3
) would
return
'
Net
'
substr(
'
TechOnTheNet
'
,
-
6
,
3
) would
return
'
The
'
如: substr(
'
This is a test
'
,
6
,
2
) would
return
'
is
'
substr(
'
This is a test
'
,
6
) would
return
'
is a test
'
substr(
'
TechOnTheNet
'
,
-
3
,
3
) would
return
'
Net
'
substr(
'
TechOnTheNet
'
,
-
6
,
3
) would
return
'
The
'
select
substr(
'
Thisisatest
'
,
-
4
,
2
) value
from
dual
1万+
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
