Viewing synonyms and what they reference. : all_synonyms « System Tables Data Dictionary « Oracle PL/SQL Tutorial






  1. Oracle PL/SQL Tutorial
  2. System Tables Data Dictionary
  3. all_synonyms
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>








30.14.all_synonyms
30.14.1.Query all_synonyms
30.14.2.Viewing synonyms and what they reference.