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
相关阅读
tnsnames.ora是什么东西?a questionRe: Make your own dynamic page todayAny Chinese Tutorial for Access Programming?help!how to enlarge the size of master device!ACT4.0 (Symantec)Is there any small free database support Java ?有谁会用ode4.1?[转载] Whcich DB Software to Install?want help on RDBMShow to update oracle view by delphiRe: Oracle DBA[转载] LDAP + SQLUrgent help needed, pleaseSPSS question第二课 见识一下面向对象的编程How to extract data from webOracle 8i for Linux如何建基于WWW的BBS?最早的debase(拼法正确否)有没有unix下的版本呢？