Return
-
Title
Unable to apply lowercase column name with an uppercase alias name when using Toad Insight -
Description
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
Sign In Required
You need to be signed in and under a current maintenance contract to view premium knowledge articles.