I have just updated to Toad for Oracle 188.8.131.52 and have discovered a new “feature” when multiple tables in the same editor (in different statements) are given the same alias…
Previously, the pick list returned the columns from the table within the relevant statement. Now it returns the columns from the top table with the specific alias even if the cursor is in a completely different statement.
I have included a screen print below. As can be seen does the pick list show the columns from “all_tables” and not “all_tab_columns” as I would like it to.
Can this be changed anywhere. It is really annoying as I have always used a,b,c,d,… as alias.
In advance, thanks