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 vote255 views1 answer
Drop all data from tables
SQL
0 vote323 views2 answers
Fanyi
SQL
1 vote290 views1 answer
Influxdb export to csv
SQL
0 vote277 views1 answer
Java check if something is in mysql table
SQL
1 vote279 views3 answers
Java.sql.sqlexception: access denied for user
SQL
1 vote267 views1 answer
Postgres delete from where date is greater than specific date
SQL
1 vote283 views2 answers
Select into temp table
SQL
0 vote286 views1 answer
Oracle date winter time
SQL
0 vote309 views1 answer
Database schema for mcqs type exam in sql
SQL
1 vote330 views1 answer
How to check all scheduled jobs in oracle
SQL