Code Assist does not work after the GROUP BY or ON statements in version 12.8.
Typing a simple query,
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 alias (“e.”) there is a delay of a second and returns nothing.
This frequently happens on the ON clause when adding in a table JOIN or LEFT OUTER JOIN, as well. .
You need to be signed in and under a current maintenance contract to view premium knowledge articles.