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');