最新下载
热门教程
- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9
- 10
oralce substr字符截取函数用法
时间:2022-06-29 10:10:05 编辑:袖梨 来源:一聚教程网
在几乎所有的数据库教程中都会有字符截取这个函数,都大同小义了,下面我们来看看在Oralce中有个数据切割函数: substr的用法吧。
substr('要切割的值',从第几个位置开始切割,切割几位);
如下例:
view sourceprint?substr('hello word', 3, 2) would return 'll'
substr('hello word', 5) would return 'o word'
substr('hello word', -3, 3) would return 'ord'
substr('hello word', -6, 3) would return 'o w'
substr('hello word', -8, 2) would return 'll'
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.
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'
相关文章
- 剑星桃乐丝服装怎么获取 桃乐丝服装获取方式介绍 07-12
- 无畏契约源能行动星礈怎么玩 星礈实战技巧教学 07-12
- 魔兽世界wlk血精灵怎么练级-wlk血精灵练级路线推荐 07-12
- 前端水印的简单实现代码示例 07-12
- ps后期调出大光比的古风人像大片教程 07-12
- 幻兽帕鲁雷鸣童子值得捕捉吗 帕鲁雷鸣童子抓捕建议分享 07-12