Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / System Tables Data Dictionary

 

Viewing synonyms and what they reference

SQL>  select owner, synonym_name, table_owner, table_name   2    from all_synonyms   3   where synonym_name='JOBS' and rownum < 6; no rows selected SQL>