Get ALL SYNONYMS : ALL_SYNONYMS « System Tables Views « Oracle PL / SQL






Get ALL SYNONYMS

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

SYNONYM_NAME                   TABLE_OWNER                    TABLE_NAME
------------------------------ ------------------------------ ------------------------------
HTMLDB_ACTIVITY_LOG            FLOWS_020100                   WWV_FLOW_USER_ACTIVITY_LOG
HTMLDB_APPLICATION             FLOWS_020100                   WWV_FLOW
HTMLDB_APPLICATION_FILES       FLOWS_020100                   WWV_FLOW_FILES
HTMLDB_APPLICATION_GLOBAL      FLOWS_020100                   WWV_FLOW_GLOBAL
HTMLDB_COLLECTION              FLOWS_020100                   WWV_FLOW_COLLECTION
HTMLDB_COLLECTIONS             FLOWS_020100                   WWV_FLOW_COLLECTIONS
HTMLDB_LDAP                    FLOWS_020100                   WWV_FLOW_LDAP
HTMLDB_MAIL                    FLOWS_020100                   WWV_FLOW_MAIL
HTMLDB_MAIL_LOG                FLOWS_020100                   WWV_FLOW_USER_MAIL_LOG

9 rows selected.

SQL>
SQL>

           
       








Related examples in the same category