oracle substr 操作
在Oralce中有个数据切割函数: substr。
substr('要切割的值',从第几个位置开始切割,切割几位);
如下例:
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'