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
相关阅读
如何设计这个数据表更好？请教：web hosting用windows+mysqlwhich sys sp (sql server) show all user sp and functions?oracle菜鸟问题。要离开现在这个职位，公司希望能推荐一个DBAInteresting Data Manipulation questionsql请教SQL 2008 Create Index vs Rebuild Index (Alter Index)怎么查找出所有类似的产品？发一个在BWI附近的dba 工作为什么微软专家给一个4x5的只读小表建64个Index(完全相同的)?请教高手：想考Oracle的data warehouse认证，不知有没有价值问个silly question網絡數據安全問題如何在Oracle XE上安装OE schemaT-SQL 问题为什么我不能Access linked server objectteradata和oracle比较how to get command history in sqlpus within Screen shell?公司要升级了，问题