In Toad for Oracle v9.7.2.5, it's not possible to have a lowercase column name with an uppercase alias name, when selected from the Toad Insight pick-list.
The script / syntax ideally trying to be achieved is as follows:
SELECT * FROM table_name ALIAS WHERE ALIAS.column_name
However, in v9.7.2, it's only possible to get the following results:
SELECT * FROM table_name ALIAS WHERE alias.column_name
or
SELECT * FROM table_name ALIAS WHERE ALIAS.COLUMN_NAME
WORKAROUND:
None.
STATUS:
Waiting for fix in a future release of Toad for Oracle.
This is possible in Toad for Oracle v9.1.0.62.
