Get user SYNONYMS : USER_SYNONYMS « System Tables Views « Oracle PL / SQL






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