Mega Code Archive

 

Categories / Oracle PLSQL / User Previliege

 

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> SQL> SQL>