Oracle PL/SQL/System Tables Views/ALL SYNONYMS

Get ALL SYNONYMS

SQL>
SQL>
SQL> SELECT synonym_name, table_owner, table_name
  2  FROM ALL_SYNONYMS where rownum < 10;
SYNONYM_NAME                   TABLE_OWNER                    TABLE_NAME
------------------------------ ------------------------------ ------------------------------
HTMLDB_ACTIVITY_LOG            FLOWS_020100                   WWV_FLOW_USER_ACTIVITY_LOG
HTMLDB_APPLICATION             FLOWS_020100                   WWV_FLOW
HTMLDB_APPLICATION_FILES       FLOWS_020100                   WWV_FLOW_FILES
HTMLDB_APPLICATION_GLOBAL      FLOWS_020100                   WWV_FLOW_GLOBAL
HTMLDB_COLLECTION              FLOWS_020100                   WWV_FLOW_COLLECTION
HTMLDB_COLLECTIONS             FLOWS_020100                   WWV_FLOW_COLLECTIONS
HTMLDB_LDAP                    FLOWS_020100                   WWV_FLOW_LDAP
HTMLDB_MAIL                    FLOWS_020100                   WWV_FLOW_MAIL
HTMLDB_MAIL_LOG                FLOWS_020100                   WWV_FLOW_USER_MAIL_LOG
9 rows selected.
SQL>
SQL>