Oracle PL/SQL/System Tables Views/USER SYNONYMS

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>