Synonyms (study notes) and synonyms (study notes)

Synonyms (study notes) and synonyms (study notes)
Synonym = table alias

Syntax:
CREATE [PUBLIC] SYNONYM name FOR database object;

Example 1,

-- Users created by the administrator or users with the permission to CREATE synonyms -- CREATE the synonym conn sys/change_on_install as sysdba for scott; create synonym myemp FOR scott. emp -- use scott to log on to select * from myemp; -- the effect is the same as that of select * from emp;

Check whether the synonym is created successfully.

SELECT * FROM User_Synonyms;

To create a public synonym, addPublic,In this way, any user with query permission can use

Log on as an administrator and create a public synonym.

Create public synonym myemp FOR scott. emp;

To create a new user and log on to or use another user to log on, you can perform the following steps:

-- Execute SELECT * FROM myemp;

Delete synonym syntax
Drop synonym name

Drop synonym myemp;