Synonyms (study notes)

synonym = alias of table

Grammar:
CREATE [public] synonym synonym name for database object;

Example One,

 --  user created with administrator or with the Create SYNONYM permission  --  create synonyms for Scott  CONN sys/ Change_ On_install as   SYSDBA;  create  Synonym myemp  scott.emp  --  select  *  from   myemp;  --  select  *  from  emp; 

Query whether synonyms are created successfully

SELECT *  from user_synonyms;

If you want to create a common synonym, you only need to precede it with public , so any user with query permission can use the

Log on with an administrator, and create a public synonym

CREATE  Public  for Scott.emp;

Create a new user and log in or, using another user login, you can perform the following

-- Execution SELECT *  from Myemp;

Syntax for deleting synonyms
DROP synonym synonym Name

DROP Synonym Myemp;

Synonyms (study notes)