Sql Regex pattern Find

moh_sul · July 1, 2019, 10:14am

Hi Team i need to find the position of the particular pattern in the provided string.

I have used Patindex in MSQl like below, but im not sure how to get the same output in Oracle.

Please help me on this.

the query that is used in MSQL

select patindex('%S[0-9][0-9]%','hi this is aaaaaaaa S123456789 therefor here');

O/p
21

harishgg1 · July 1, 2019, 1:52pm

maybe this can help you