Топ-100
top of page
CerebroSQL

CREATE SYNONYM

RDBMS Type: Oracle

CREATE [ OR REPLACE ] [ PUBLIC ] SYNONYM
[ schema. ] synonym
FOR [ schema. ] object [ @ dblink ] ;

Example

CREATE SYNONYM offices
FOR hr.locations;

CREATE PUBLIC SYNONYM emp_table
FOR hr.employees@remote.us.example.com;

CREATE PUBLIC SYNONYM customers FOR oe.customers;

bottom of page