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

13 votes218 views2 answers
Oracle inner join
SQL
1 vote174 views1 answer
Launch sql script from docker in mysql
SQL
1 vote236 views1 answer
Check current sequence value postgres
SQL
0 vote222 views1 answer
Where to find pg_hba.conf in ubuntu
SQL
0 vote224 views1 answer
Import mysql'
SQL
1 vote184 views4 answers
Psql check tables command
SQL
0 vote220 views1 answer
Mysql récupérer le code création de vue
SQL
0 vote222 views1 answer
Oracle list dblink
SQL
6 votes192 views1 answer
Oracle desc table primary key
SQL
0 vote188 views1 answer
Update table sql multiple set
SQL