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 vote202 views1 answer
Select sql in descending order
SQL
0 vote286 views1 answer
Sqlite send a query to a Sqlite DB with Ruby
SQL
0 vote211 views1 answer
Use where instead of join
SQL
0 vote182 views1 answer
Excute raw query
SQL
9 votes201 views3 answers
Oracle undo usage by session
SQL
2 votes212 views1 answer
Node and mysql like
SQL
13 votes252 views3 answers
Sql online code
SQL
0 vote266 views1 answer
Merge clause with inner join
SQL
0 vote202 views1 answer
Disableforiegn key check
SQL
13 votes222 views3 answers
List all the tables in sql
SQL