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

12 votes322 views2 answers
Delete all nodes neo4j
SQL
1 vote289 views1 answer
Alter user mysql native password
SQL
0 vote330 views1 answer
Replace string in whole database mysql stackoverflow
SQL
3 votes332 views2 answers
Get current year sql
SQL
1 vote309 views1 answer
Autocommit mysql
SQL
0 vote318 views1 answer
Mysql workbench primary key
SQL
1 vote332 views1 answer
Sql sort column by date
SQL
0 vote325 views1 answer
Import excel to sql
SQL
0 vote339 views1 answer
Get current date data in mysql
SQL
1 vote329 views1 answer
Calculate age in sql postgresql
SQL