Return
-
Title
Extra parenthesis added when using a WHERE clause with substring in Query Builder -
Description
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'
-
Resolution
WORKAROUND:
Manually edit the statement and remove the extra parenthesis characters.
STATUS:
Waiting for fix in a future release of Toad for Oracle -
Defect ID
CR 116558