Oracle 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;

SELECT * FROM DBA_SYNONYMS WHERE SYNONYM_NAME = 'synonym_name';

Synonym oracle

CREATE OR REPLACE PUBLIC SYNONYM suppliers FOR app.suppliers;

Similar codes

0 vote328 views1 answer
Sql server size of every table in a db
SQL
1 vote311 views1 answer
Postgresql filter on
SQL
0 vote357 views1 answer
Select distinct after join
SQL
3 votes329 views2 answers
Java.sql.SQLException: Unknown initial character set index '255' received from server. Initial client character set can be forced via the 'characterEncoding' property.
SQL
0 vote344 views1 answer
Openquery join two tables
SQL
1 vote317 views1 answer
Media sql
SQL
1 vote312 views10 answers
Stack overflow
SQL
4 votes326 views1 answer
Sql any
SQL
0 vote378 views1 answer
Postgresql alter table sequence
SQL
1 vote321 views1 answer
Postgres concat_ws
SQL