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

0 vote238 views1 answer
Flask sqlalchemy. commit does not save changes
SQL
5 votes227 views1 answer
Get column name sql server
SQL
1 vote242 views2 answers
Postgresql check privileges on schema
SQL
0 vote233 views1 answer
Firebase sql
SQL
0 vote218 views1 answer
Sql recherche nom prenom
SQL
0 vote227 views3 answers
Run sql command line
SQL
3 votes228 views1 answer
Stpop start psql server
SQL
0 vote226 views1 answer
Sql server Cost Fifo query
SQL
0 vote250 views1 answer
Mysql get nth highest
SQL
0 vote229 views2 answers
Mysql two column combination unique
SQL