Mega Code Archive

 

Categories / Oracle PLSQL / System Tables Views

 

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>