Oracle create synonym

-- Can be a table, package, procedure...
CREATE OR REPLACE SYNONYM syn_name FOR my_schema.my_table;      
CREATE OR REPLACE PUBLIC SYNONYM syn_name FOR my_schema.my_table;

-- Through a dblink:
CREATE OR REPLACE SYNONYM syn_name FOR my_schema.my_table@my_dblink;

Synonym oracle

CREATE OR REPLACE PUBLIC SYNONYM suppliers FOR app.suppliers;

Similar codes

0 vote192 views1 answer
Mysql set boolean default value
SQL
0 vote176 views1 answer
Mysql get 2nd value in comma separated list
SQL
0 vote214 views1 answer
Where to find pg_hba.conf in ubuntu
SQL
5 votes182 views1 answer
How to get all dates in a month in oracle
SQL
3 votes185 views5 answers
Mysql get last inserted id
SQL
6 votes204 views2 answers
Difference between join vs union
SQL
0 vote178 views1 answer
INSERT INTO table using OpenQuery
SQL
0 vote183 views1 answer
Starting mysql shell lampp ubuntu
SQL
1 vote284 views4 answers
Alter schema sql
SQL
0 vote230 views1 answer
Mysql c commands
SQL