Toad for Oracle 12.8 Intellisense Code Insight Pick List is breaking or does not pop-up or appear when joining two or more tables with ANSI Join.
Examples:
Code Insight Pick List will work on all tables not in an ANSI Join, and with the LAST table in the ANSI Join. In this case, Insight works for tables 3 through 5 (c, d, and e), but not on tables 1 or 2 (a or b):
SELECT *
FROM table1 a
INNER JOIN table2 b ON 1 = 1
INNER JOIN table3 c ON 1 = 1,
table4 d,
table5 e;
If all tables are ANSI Joined together, Code Insight Pick List only works for the last table. In this case, it is table5 (e):
SELECT *
FROM table1 a
INNER JOIN table2 b ON 1 = 1
INNER JOIN table3 c ON 1 = 1
INNER JOIN table4 d ON 1 = 1
INNER JOIN table5 e ON 1 = 1;
WORKAROUND:
None
STATUS:
Issue fixed in version 12.9. The latest version of Toad for Oracle can be downloaded here.
