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 votes203 views1 answer
Postgresql transaction
SQL
0 vote197 views1 answer
Get all employee of salary if more than in sql
SQL
1 vote198 views1 answer
Drop function
SQL
2 votes200 views1 answer
Possgress drop if exists table
SQL
4 votes331 views6 answers
Laravel jwt
SQL
0 vote188 views1 answer
Sql select most frequent value in group
SQL
1 vote185 views1 answer
Column with prefix in sql
SQL
1 vote218 views1 answer
Vagrant mysql downgrade version
SQL
0 vote193 views1 answer
Sql get guid
SQL
61 votes313 views6 answers
Mysql add column
SQL