many thank’s for your answer.
I see and use synonyms in TOAD for SS.
My request is little differrent…
With synonyms I type in sql editor for example - select - code completion show me the lists of tables and I select one. After this operation cursor goes between - select - and - from - sql reserved keywords.
At this point I must to return at the end of the SQL statement and type synonym for my table.
Now I return between - select and from keywords - and type synonym, press CTRL + . and fields appear correctly.
To works better it’s more useful if when the lists of the tables appear in code completion and I select one, code completion insert automatically table name and the relative synonym for it.
At this point when the cursor return between select and from sql keywords, I can type synonym , press CTRL + . and the fields appears correctly.
This example is based on a simple SQL select statement.
Imagine when the sql statement is more complex with join, etc,etc…
If I use a join between two tables when I return between select and from keywords to insert fields i have two possibility :
insert manually tablename with point ‘.’ and code completion show me the fields of the table.
Use a previous synonym created in from or join clause and the press CTRL + ‘.’ to select field of the table/synonym.
I prefer the second method but every time I must create synonym manually.
If I understand correctly synonym in TOAD isn’t created automatically by your product.
I stay tune for your consideration…