oracle equivalent of patindex and instr function with wild card characters
Posted
by Jack
on Stack Overflow
See other posts from Stack Overflow
or by Jack
Published on 2010-05-04T22:19:43Z
Indexed on
2010/05/04
22:28 UTC
Read the original article
Hit count: 308
Filed under:
Oracle
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')
© Stack Overflow or respective owner
