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

11 votes248 views4 answers
Update row in mysql
SQL
1 vote238 views2 answers
How to check if sql query is correct online
SQL
2 votes260 views1 answer
Install postgresql centos 5
SQL
0 vote236 views1 answer
Mysql vs sql server performance benchmark
SQL
3 votes238 views2 answers
How to load files in mysql
SQL
0 vote283 views1 answer
Jpa generationtype sequence mysql
SQL
0 vote259 views1 answer
Sql server for loop
SQL
10 votes276 views4 answers
Sql server pagination
SQL
1 vote253 views3 answers
Sql procedure
SQL
6 votes250 views3 answers
Update with inner join postgres
SQL