Hi,
Let's suppose I have a string
str := ' ((Hello ( Hi Hi hi ( A B C ( D)) (EF)
why Whwy whyhhh )
)
)'
Now I need to find the matching bracket position for the 3rd bracket. Is their a way we can do the same using SQL.
in PL SQL I can do the same using +1,-1 logic, say start from the position of 3rd bracket, keep adding 1 for ( and - 1 for ) and wait till 0. But is there any other better way. maybe regex or something.
Thanks