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."
The addition of the schema name before the table name is throwing off the code assist.
WORKAROUND:
Do not specify the schema with the table name. I.e. SELECT st.Column1 FROM Some_tbl st -- no schema name included.
STATUS:
Waiting for fix in a future version of Toad for Oracle.
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center