This will allows you for searching through a string for set of
characters.
Syntax: instr (string, search_str
[, start_chr_count [, occurrence] ])
Ex:
SQL> select instr('information','o',4,1),
instr('information','o',4,2) from dual;
INSTR('INFORMATION','O',4,1)
INSTR('INFORMATION','O',4,2)
------------------------------------ -------------------------------------
4 10
Ø If you are not
specifying start_chr_count and occurrence then it will start
search from the beginning and finds first
occurrence only.
Ø If both
parameters start_chr_count and occurrence are null, it will display
nothing.
