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 vote304 views1 answer
Postgresql append array
SQL
7 votes290 views1 answer
Sql limit decimal places
SQL
2 votes314 views1 answer
Rails execute sql
SQL
42 votes388 views6 answers
Rename table sql server
SQL
0 vote270 views1 answer
Is numeric in sql
SQL
6 votes290 views2 answers
How to copy data in sql
SQL
2 votes319 views2 answers
Mysql bidirectional composite primary key
SQL
0 vote316 views1 answer
Space not removing from column in sql
SQL
5 votes312 views2 answers
Mysqldump password
SQL
0 vote299 views1 answer
Alter table engine mysql
SQL