Oracle PL/SQL/System Tables Views/DBA SYNONYMS

Get DBA SYNONYMS

   <source lang="sql">

SQL> SQL> SELECT synonym_name, table_owner, table_name

 2  FROM DBA_SYNONYMS where rownum < 10;

SYNONYM_NAME TABLE_OWNER TABLE_NAME

---

------------------------------ ------------------------------

DUAL SYS DUAL SYSTEM_PRIVILEGE_MAP SYS SYSTEM_PRIVILEGE_MAP TABLE_PRIVILEGE_MAP SYS TABLE_PRIVILEGE_MAP STMT_AUDIT_OPTION_MAP SYS STMT_AUDIT_OPTION_MAP MAP_OBJECT SYS MAP_OBJECT DBMS_STANDARD SYS DBMS_STANDARD V$MAP_LIBRARY SYS V_$MAP_LIBRARY V$MAP_FILE SYS V_$MAP_FILE V$MAP_FILE_EXTENT SYS V_$MAP_FILE_EXTENT 9 rows selected. SQL>

      </source>