Oracle9i study note 11 (3) Synonyms

1. Create a synonym
Create [public] synonym Synonym
For object;

Example 1: Create a concise name for view dept_sum_vu
Create synonym d_sum for dept_sum_vu;
Example 2: create a public synonym for all users
Create public synonym dept for Scott. Dept;

2. query Synonyms
1) query private Synonyms
Select synonym_name, table_owner, table_name
From user_synonyms;
2) Public synonym Query
Select owner, synonym_name, table_owner, table_name
From all_synonyms
Where table_owner = 'Scott'
And owner = 'public ';

3. Delete Synonyms
1) delete a private Synonym
Drop synonym d_dum;
2) delete a public Synonym
Drop public synonym EMP;