Get DBA SYNONYMS : DBA_SYNONYMS « System Tables Views « Oracle PL / SQL






Get DBA SYNONYMS


SQL>
SQL> SELECT synonym_name, table_owner, table_name
  2  FROM DBA_SYNONYMS where rownum < 10;

SYNONYM_NAME                   TABLE_OWNER                    TABLE_NAME
------------------------------ ------------------------------ ------------------------------
DUAL                           SYS                            DUAL
SYSTEM_PRIVILEGE_MAP           SYS                            SYSTEM_PRIVILEGE_MAP
TABLE_PRIVILEGE_MAP            SYS                            TABLE_PRIVILEGE_MAP
STMT_AUDIT_OPTION_MAP          SYS                            STMT_AUDIT_OPTION_MAP
MAP_OBJECT                     SYS                            MAP_OBJECT
DBMS_STANDARD                  SYS                            DBMS_STANDARD
V$MAP_LIBRARY                  SYS                            V_$MAP_LIBRARY
V$MAP_FILE                     SYS                            V_$MAP_FILE
V$MAP_FILE_EXTENT              SYS                            V_$MAP_FILE_EXTENT

9 rows selected.

SQL>
           
       








Related examples in the same category