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 vote189 views1 answer
Sql delimiter to columns
SQL
0 vote189 views1 answer
Setval postgres example table id
SQL
3 votes210 views2 answers
Wp do sql query from function
SQL
2 votes192 views1 answer
How to search table name in stored procedure in sql server
SQL
0 vote211 views1 answer
SQL SERVER xquery count child nodes
SQL
0 vote198 views1 answer
Python sqlalchemy connection show server
SQL
0 vote195 views1 answer
Console output pl sql
SQL
6 votes189 views2 answers
Mysql set primary key
SQL
0 vote197 views1 answer
Postgresql not in alternative
SQL
0 vote183 views1 answer
Linux upload database to mysql
SQL