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 vote318 views2 answers
Insert data into multiple tables mysql
SQL
1 vote252 views1 answer
Postgres convert exisiting column to text
SQL
0 vote255 views1 answer
Sql contains numeric characters
SQL
0 vote251 views1 answer
Use where instead of join
SQL
2 votes252 views1 answer
Sql create database
SQL
0 vote252 views1 answer
Add unique constraint sql server multiple columns
SQL
0 vote255 views1 answer
Learn sqlite dart
SQL
0 vote268 views1 answer
Mysql milliseconds
SQL
25 votes271 views5 answers
Date in mysql
SQL
0 vote262 views1 answer
Is not sql
SQL