Model Regex Find Sql

Hello,
Need to find the location of the specific pattern in the provided string.

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

Please help me on this.

Tks!

John

Hi

Please see if this link helps