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

7 votes165 views1 answer
Append column sql
SQL
0 vote211 views1 answer
Replace \n sql
SQL
0 vote173 views1 answer
Mysql streaming example
SQL
0 vote171 views1 answer
What alter does in db
SQL
7 votes254 views2 answers
Oracle foreign key reference table
SQL
0 vote243 views1 answer
How to login to mysql in homestead
SQL
2 votes187 views1 answer
Where clause for child record apex
SQL
2 votes192 views1 answer
Postgresql resolv duplicate value violates unique constraint
SQL
0 vote174 views1 answer
Postgresql create query
SQL
7 votes188 views3 answers
Can't connect to local mysql server through socket '/tmp/mysql.sock' (2)
SQL