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

3 votes182 views5 answers
ModuleNotFoundError: No module named 'MySQLdb'
SQL
0 vote193 views1 answer
Postgres populate table from another table
SQL
0 vote182 views1 answer
Mysql count by month
SQL
12 votes208 views1 answer
Run mysql instance in docker
SQL
3 votes223 views1 answer
Mysql group_concat distinct
SQL
0 vote173 views1 answer
Mysql find db contarint
SQL
28 votes200 views6 answers
Sql update
SQL
0 vote183 views1 answer
Oracle SQL join three tables and group by column
SQL
0 vote179 views1 answer
Mysql table variables
SQL
0 vote189 views1 answer
Mysql get last 2 month data
SQL