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

4 votes284 views1 answer
Oracle show error line number
SQL
1 vote386 views2 answers
Begin transaction sql
SQL
-3 votes285 views1 answer
Remove spaces sql 2008
SQL
1 vote307 views1 answer
Pl sql ptint
SQL
2 votes314 views2 answers
Sql query to copy data from one column to another
SQL
0 vote318 views3 answers
How to modify alter user root@localhost identified with mysql_native_password by properly
SQL
0 vote299 views1 answer
Can we rollback data that are deleted using DELETE
SQL
3 votes322 views1 answer
APEX elapsed time
SQL
0 vote307 views1 answer
Sql server separar numeros por comas miles
SQL
0 vote319 views1 answer
What does leave do in mysql
SQL