Mega Code Archive

 

Categories / Oracle PLSQL / System Tables Views

 

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>