Oracle PL/SQL/System Tables Views/USER SYNONYMS
Get user SYNONYMS
<source lang="sql">
SQL> SQL> SELECT synonym_name, table_owner, table_name
2 FROM USER_SYNONYMS where rownum < 10;
SYNONYM_NAME TABLE_OWNER TABLE_NAME
------------------------------ ------------------------------
DEF$_AQCALL SYSTEM DEF$_AQCALL DEF$_CALLDEST SYSTEM DEF$_CALLDEST DEF$_DEFAULTDEST SYSTEM DEF$_DEFAULTDEST DEF$_ERROR SYSTEM DEF$_ERROR DEF$_LOB SYSTEM DEF$_LOB DEF$_SCHEDULE SYSTEM DEF$_SCHEDULE XMLDOM XDB DBMS_XMLDOM XMLPARSER XDB DBMS_XMLPARSER XSLPROCESSOR XDB DBMS_XSLPROCESSOR 9 rows selected. SQL> SQL>
</source>