Query all_synonyms : all_synonyms « System Tables Data Dictionary « Oracle PL/SQL Tutorial

1. Oracle PL/SQL Tutorial
2. System Tables Data Dictionary
3. all_synonyms

SQL>
SQL> SELECT owner, synonym_name
  2  FROM all_synonyms
  3  WHERE table_owner = 'SYS' AND table_name = 'ALL_TABLES';
PUBLIC     ALL_TABLES

1 row selected.

SQL>
SQL>