Toad 12.5 Oracle Editor replaces my TABLE ALIAS name with FULL TABLE name when using COLUMN PICK LIST. I WANT TO STOP THIS. HOW DO I STOP THIS?
I type this into the EDITOR:
select * from ODS.ODS_UDC_MASTER udc
and then replace the * with udc. to invoke the picklist. When I select a column name the ‘udc.’ is replaced with ODS_UDC_MASTER and the SQL fails because the ALIAS is not used.
How do I stop this from happening? I can not find a setting to stop it.