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 vote205 views1 answer
Product of a column in mysql
SQL
6 votes185 views1 answer
Phpmyadmin reset root password
SQL
0 vote194 views2 answers
MySQL top percent
SQL
25 votes215 views6 answers
How to change column name in mysql
SQL
0 vote200 views1 answer
Min and max salary and name in sql
SQL
0 vote164 views1 answer
Plsql trigger insert update
SQL
0 vote204 views1 answer
Qt qsql check if table exist
SQL
5 votes220 views2 answers
Mysql dump mysql db cli
SQL
0 vote207 views1 answer
Mysql random number between 1 and 100
SQL
0 vote215 views1 answer
Select all columns except one sql
SQL