oracle sql截取数据长度

substr(aaabbbbvvvcccc,1,4)='2009'

这是Oracle的用法将xc_qj这个字段的数据从第一位开始截取四位

语法

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.

start_position用负数则从右边开始数第几个位置

举例: substr('This is a test',6,2)would return 'is' substr('This is a test',6)would return 'is a test' substr('TechOnTheNet',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'

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!