a*c
2 楼
INSTR searches char1 beginning with its nth character for the mth occurrence
of char2 and returns the position of the character in char1 that is the first
character of this occurrence. If n is negative, Oracle counts and searches
backward from the end of char1. The value of m must be positive. The default
values of both n and m are 1, meaning Oracle begins searching at the first
character of char1 for the first occurrence of char2. The return value is
relative to the beginning of char1, regardle
of char2 and returns the position of the character in char1 that is the first
character of this occurrence. If n is negative, Oracle counts and searches
backward from the end of char1. The value of m must be positive. The default
values of both n and m are 1, meaning Oracle begins searching at the first
character of char1 for the first occurrence of char2. The return value is
relative to the beginning of char1, regardle
n*l
3 楼
Thank you very much! Basically it is returning the specified string character
position. A very neat function. Thank also for the OTN info.
first
【在 a****c 的大作中提到】
: INSTR searches char1 beginning with its nth character for the mth occurrence
: of char2 and returns the position of the character in char1 that is the first
: character of this occurrence. If n is negative, Oracle counts and searches
: backward from the end of char1. The value of m must be positive. The default
: values of both n and m are 1, meaning Oracle begins searching at the first
: character of char1 for the first occurrence of char2. The return value is
: relative to the beginning of char1, regardle
position. A very neat function. Thank also for the OTN info.
first
【在 a****c 的大作中提到】
: INSTR searches char1 beginning with its nth character for the mth occurrence
: of char2 and returns the position of the character in char1 that is the first
: character of this occurrence. If n is negative, Oracle counts and searches
: backward from the end of char1. The value of m must be positive. The default
: values of both n and m are 1, meaning Oracle begins searching at the first
: character of char1 for the first occurrence of char2. The return value is
: relative to the beginning of char1, regardle
相关阅读
关于学习数据库我也说几句两年前的真题库是不是太旧了?化学在读博士转计算机,求建议。 (转载)找个码工就这么难?新一代数据库 RavenDBHow to find all duplicate record in SQL?装不上SQL 2008SQL Server 2012什么时候会开始流行?"走进Oracle的世界,走近Informatica" 网上互动交流会!SSIS DYNAMIC EXCEL输出的问题找SQL developer的工作应该考什么证书啊70-433 evaluation SQL 2008 Enterprise CD请问有sql server彻底remove的工具吗?create linked server problem, please help请教 oracle sql developer超龄大妈要改行,寻求建议,谢谢!论这两年不断突破心理底线的互联网薪水 zt (转载)第一贴:有木免费的SSMS svn plugin?谢!redgate太贵EBS On ExaRe: negotiate弄砸offer了吗?求祝福! (转载)