Synonym oracle

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

2 votes120 views4 answers
Mysql get all tables row count
SQL
12 votes136 views1 answer
Run mysql instance in docker
SQL
47 votes188 views6 answers
Add column mysql
SQL
0 vote165 views1 answer
How to compile a function in oracle
SQL
-1 vote151 views4 answers
Full outer join in sql
SQL
6 votes117 views2 answers
Mysql set primary key
SQL
4 votes113 views1 answer
Force drop all tables postgres
SQL
2 votes126 views1 answer
Drop all foreign key constraints mysql
SQL
7 votes126 views2 answers
How to create index mysql
SQL
4 votes116 views3 answers
Mysql update with join
SQL