Oracle INSTR function | Oracle instr() syntax | How to use oracle INSTR
Oracle INSTR() function
INSTR(str, chars[,s[,n]]) Find the 'n'th occurence of 'chars' in 'str' Starting at position 's'
n and s default to 1
select instr('oracle database','a') from dual
Result: 3
select instr('oracle database','a',6) from dual
Result : 9
select instr('oracle database','a',6,2) from dual
Result : 11
select instr('oracle database','a',6,2) from dual
Result : 11
INSTRB (str, chars[,s[,n]])
The same as INSTR, except that 's' and the return value are expressed in bytes,
use for double-byte char sets More functions : Oracle add_months function | Oracle ASCII function | Oracle DECODE function
|
|
Page 1
|
| 
