oracle equivalent of patindex and instr function with wild card characters
- by Jack
is there an oracle equivalent of patindex? from my search, the only function that is close to patindex is oracle's instr function but it does not support wild card.
what is the oracle equivalent of the following query?
select patindex('%[^0]%','00194505022')