In Toad 12.6 and 12.7, extra parenthesis characters are added in a where clause with a substring function.
For example:
================================
SELECT c1, c2
FROM TABLE
WHERE SUBSTR (c1, 1, 1) IN ( ('A', 'B'))
================================
When you run this statement, you see the error 'Missing right parenthesis'
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center