While working in Toad for Oracle 11 and working with Query Builder, add an alias to a column. This gets added to the SQL correctly and correctly displays in the builder. But if this is saved (.dml) and reopened, the column alias seem to be missing. It is no longer applied in the SQL though the alias is still listed in the diagram/builder window. It still shows up in the left panel "Mode: Select". The actual query generated in the query tab at the bottom does not include the alias in the query, and running the query does not apply the column alias.
,
The issue seems to be with how 11.0 is saving the dml.
WORKAROUND:
None in Toad 11. If planning to save and use later, create and save from Toad 10.6. Files created in 10.6 are properly saved and can be opened using Toad 11 (and others).
STATUS:
Waiting for fix in a future version of Toad for Oracle.
This is not a problem in 10.6
