Code assistant in Toad for Oracle 12.5 is not behaving like it used to in previous releases.
When in editor and specifying an alias for a table in the SQL statement, when trying to select a column from the code assist pop up list (type in the table alias, then the dot) it gives column names appended with the full table name, not just the alias.
Expect:
SELECT st.Column1 FROM UserA.Some_tbl st
Unexpected SQL:
SELECT Some_tbl.Column1 FROM UserA.Some_tbl st -- automatically uses "Some_table." instead of "st."
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center