Toad World® Forums

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?

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.

This has been reported and it’s fixed for the first 12.6 beta. The problem surfaces when qualifying your object names with the schema when you are either logged in as that schema or when that schema is your default schema set in the current schema dropdown on the Editor toolbar. The only workaround is to not specify your schema name if that is your logged in or default schema.

Michael