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 的大作中提到】![](/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
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
相关阅读
MySQLoralce8 and UTF8 supportRe: [转载] How to remote access the Access Database file besides throu有数据库高高手吗?Y2K No.1~~睡知道什么地方能下载统计软件--SAS请问有什么站点提供一些oracle dba的类似考题吗?600了~{Gk=L~} CS expert !!!How to import database into MySQL?[转载] How to remote access the Access Database file besides through System DSN?Question?which part to install for Oracle8i for 98?打算自行开发一个DBMSdummy question那位大虾告诉我?Oracle 问 题 请 诸 位 大 侠 指 教, 急 急 急!!!网上哪里有关于Foxbase,DBase的电子图书教材?Why SQL Server 7 Enterprise Manager is so slow?哭诉!