In Editor window, a query of private synonym is entered using an alias name and the Code Insight list displays the synonym's column name. Once the column name is selected, Toad replaces the alias name of the synonym with the schema and synonym name.
select * from <schema name>.<synonym name> <alias name> where <alias name>.
Toad will replace the query with the following after the column name is selected:
select * from <schema name>.<synonym name> <alias name> where <schema name>.<synonym name>.<column name>
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center