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 vote287 views1 answer
Ansi sql count duplicate rows
SQL
0 vote267 views1 answer
Import big data to mysql
SQL
0 vote279 views1 answer
Plpgsql raise notice
SQL
4 votes257 views4 answers
Update select mysql
SQL
0 vote291 views3 answers
Condition in count sql
SQL
0 vote283 views1 answer
Show tables in cassandra cql
SQL
0 vote270 views1 answer
SAP Return
SQL
0 vote274 views1 answer
Sql reverse order of results
SQL
0 vote354 views1 answer
1422: Explicit or implicit commit is not allowed in stored function or trigger
SQL
28 votes264 views4 answers
Show tables mysql
SQL