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

-1 vote227 views1 answer
How to check table exists or not in postgresql
SQL
0 vote236 views1 answer
Convert .mdf to .bak
SQL
-1 vote220 views1 answer
MySQL said: Documentation #1010 - Error dropping database errno: 39 "Directory not empty")
SQL
32 votes272 views6 answers
Rename column mysql
SQL
7 votes224 views3 answers
How to check table name in current database sql
SQL
1 vote233 views1 answer
Sql select contem uma palavra
SQL
0 vote221 views1 answer
How many columns can be used for creating index?
SQL
1 vote217 views1 answer
Reutrn string after character sql
SQL
1 vote250 views1 answer
Sql group by sum with condition
SQL
0 vote221 views1 answer
Como verificar registros duplicados no sql postgresql
SQL