Synonyms : Synonyms « User Privilege « Oracle PL/SQL Tutorial






  1. Oracle PL/SQL Tutorial
  2. User Privilege
  3. Synonyms

You can access tables in another schema by specifying the schema name followed by the table.

You can avoid having to enter the schema name by creating a synonym for a table.

CREATE SYNONYM customers FOR store.customers;








36.8.Synonyms
36.8.1.Synonyms
36.8.2.Public Synonyms
36.8.3.Creating a synonym for a table
36.8.4.Creating a public synonym
36.8.5.create a synonym for a view
36.8.6.Dropping a synonym
36.8.7.Dropping a public synonym
36.8.8.Query a table by selecting its synonym
36.8.9.Seeing SYNONYM in the Oracle data dictionary
36.8.10.Describe a synonym