n*l 发帖数: 44 | 1 好不容易查到了关于instr()的解释,竟然是俄语的.
有谁知道的? 谢谢. | a****c 发帖数: 25 | 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 | n*l 发帖数: 44 | 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 的大作中提到】![](/moin_static193/solenoid/img/up.png) : 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
|
|