top of page
CerebroSQL

Oracle:

CREATE SYNONYM

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