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 vote360 views1 answer
Mod in sql
SQL
2 votes338 views1 answer
How to check grants on a package in oracle
SQL
2 votes340 views1 answer
How to insert string variable into sqlite database
SQL
1 vote327 views1 answer
Local sql server
SQL
13 votes328 views2 answers
Check if value is null mysql
SQL
1 vote324 views1 answer
Get url of cpanel database hostname
SQL
12 votes371 views1 answer
Run mysql instance in docker
SQL
51 votes715 views6 answers
Installing mysql on ubuntu
SQL
10 votes358 views2 answers
Mysql alter add foreign key
SQL
1 vote311 views1 answer
Select not matching data from two tables
SQL