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

-1 vote264 views3 answers
Update mongodb version ubuntu
SQL
0 vote290 views3 answers
How to run sql query
SQL
0 vote270 views1 answer
Drop all tables db2
SQL
0 vote291 views1 answer
Prodection ready postgres database step by step
SQL
0 vote269 views1 answer
Como hacer una consulta en sql
SQL
5 votes278 views4 answers
Rollback to in sql
SQL
0 vote264 views1 answer
Codeigniter dbforge add index
SQL
0 vote295 views2 answers
Dumping sql table
SQL
1 vote271 views1 answer
Mysql query bulk insert
SQL
3 votes256 views2 answers
Mysql add 2 hours
SQL