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

Query all_synonyms

   <source lang="sql">

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></source>

Viewing synonyms and what they reference.

   <source lang="sql">

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></source>