Get user SYNONYMS
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>
Related examples in the same category