A query is created using a table alias, e.g. "my_table_a". When typing the dot (.) to open the listing of columns in the table, and selecting a column, it changes the "my_table_a" alias in the where clause to be "my_table_a_a.column_name". There is an extra '_a'.
WORKAROUND:
Remove the underscore.
STATUS:
Issue fixed in version 12.8 of Toad for Oracle. The latest version can be downloaded here.
© 2022 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy