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