I am looking to find missing parens, both right or left, in an Oracle column of varchar. So far I have
select testcol, 'MISSING LEFT PAREN' NOTE
from test a
What I need to do is find any missing parens that should be there to match an existing one. Either right or left and if there are multiples.