Return
-
Title
Code Assist not using table alias -
Description
In the editor and alias enables Code Assist. Selecting the Code Assist loses the alias back to the full table name .
In Toad for Oracle 12.5 editor, typing the code :
SELECT *
FROM SCHEMA.TABLE T
WHERE
T.COLUMN1
Where one uses the alias T for the Table name.
Changes to:
SELECT *
FROM SCHEMA.TABLE T
WHERE
TABLE_NAME.COLUMN1
The Alias changes into the full Table name.
If the user tries to list separate columns instead of *, the alias changes to the table name as well.
SELECT
T. COLUMN1
FROM SCHEMA.TABLE T
WHERE
TABLE_NAME.COLUMN1
Changes to
SELECT
T. COLUMN1
FROM SCHEMA.TABLE T
WHERE
TABLE_NAME.COLUMN1
-
Resolution
WORKAROUND:
NoneSTATUS:
Waiting for fix in a future version of Toad for Oracle. -
Defect ID
CR 115024