Oracle PL/SQL Tutorial/System Tables Data Dictionary/all synonyms

Query 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>

Viewing synonyms and what they reference.

SQL> select owner, synonym_name, table_owner, table_name
  2    from all_synonyms
  3   where synonym_name="JOBS" and rownum < 6;
no rows selected
SQL>
SQL>
SQL>