Code Assist does not work after the GROUP BY or ON statements.
The code assist stopped working reliably after upgrading to version 12.6.
The issue happens in more often in complex queries but to easily reproduce in a simple query like this:
FROM all_inv.employee e
WHERE e.emp_status_code = ‘A’
GROUP BY e.
The code assist provided a list for the WHERE clause, but on the GROUP BY line, as soon as typing the “e.” there is a delay for second afterwards nothing is listed. This also happens almost always on the ON clause when adding in a table JOIN or LEFT OUTER JOIN.
Sign In Required
You need to be signed in and under a current maintenance contract to view premium knowledge articles.