| In oracle/PLSQL, the substr functions allows you to extract a substring from a string. 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. Ifthis 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' |
总机：(010)-88589926，88589826，88587026 QQ讨论群：243729577 182441349 邮箱：cuug_bj@cuug.com
通信地址：北京市海淀区紫竹院路98号北京化工大学科技园609室（CUUG）邮政编码：100089
中国UNIX用户协会 Copyright 2010 ALL Rights Reserved 北京神脑资讯技术有限公司
京ICP备11008061号 京公网安备110108006275号