Oracle PL/SQL/System Tables Views/USER SYNONYMS

Материал из SQL эксперт
Перейти к: навигация, поиск

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>