Code Assist does not work after the GROUP BY or ON statements in version 12.8.
For example:
Typing a simple query,
SELECT *
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.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center