A synonym is an alias for one of the following objects:
- object table
- object view
- stored procedure
- stored function
- materialized view
- java class
- used defined object object type
- another synonym
The object does not need to exist at the time of its creation.
How to create synonyms ?
SYNONYM table_name FOR table_name
How to display list of all synonyms from database ?
ORDER BY 1,2 'SYNONYM:',synonym_name,table_owner FROM USER_SYNONYMS
SELECT * FROM ALL_SYNONYMS