Viewing synonyms and what they reference. : Synonym « User Previliege « Oracle PL / SQL






  1. Oracle PL / SQL
  2. User Previliege
  3. Synonym

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>








Related examples in the same category

1.Create synonym for table
2.Creating a Public Synonym
3.Creating a Private Synonym
4.drop synonym addresses;
5.drop public synonym;
6.create synonym for a view
7.Create synonyms for dropped tables