We can use synonyms not only for select stmt, for DML commands also.
What is the advantage of creating synonym?
Generally, table name will be long.
Instead of using lengthy tables names in the SQL queries, we can use synonyms.
What is difference between table aliases and synonyms?
Do you remember, we have learnt table alias concept in joins, which helps in reducing the length of the query.
Table alias is temporary , where as synonym are permanent.
Query to see list of synonyms
Select synonym_name from user_synonyms;
When you do not want synonym, we can drop it.
Syntax
Drop synonym < synonym_name> ;