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 vote392 views1 answer
Mysql change default collation
SQL
5 votes341 views2 answers
Oracle to_timestamp
SQL
10 votes380 views2 answers
Rtrim sql
SQL
-2 votes357 views1 answer
Use of where in left join in mysql
SQL
0 vote375 views3 answers
Delete in SQL SERVER
SQL
7 votes386 views2 answers
Phpmyadmin change password
SQL
0 vote363 views2 answers
Get top 1 row of each group
SQL
8 votes378 views1 answer
Check mysql version phpmyadmin
SQL
2 votes376 views1 answer
How to delete columns in sql
SQL
0 vote388 views1 answer
Rename constraint postgresql
SQL