Description

We are recently working on OBI and found that a powerful string function of Oracle SQL is missing in logical SQL of OBI

Use Case and Business Need

Hi All,

In OBI, we are missing the powerful function on Oracle SQL

INSTR(string, substring,position, appearance)

http://docs.oracle.com/cd/B19306_01/server.102/b14200/functions068.htm

The 4th parameter is the key to its success after the nth apperance

But in OBI, we have only 2 functions

a) LOCATE(substring,string,position) -> gives the index where the substring occurs and start searches after the nth position

b) POSITION(substring,string) -> gives the index where the substring occurs

But it would be really useful if Oracle implements the INSTR function as part of logical SQL

There is also some active question around this function 

https://community.oracle.com/thread/2265190

Regards,

Kiran Shenvi

Original Idea Number: 7ddbd831e9