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 vote300 views1 answer
Drop database using terminal postgres
SQL
1 vote267 views1 answer
Mysql find tables with column name
SQL
0 vote300 views3 answers
Fetlife
SQL
1 vote300 views1 answer
Date_part mysql
SQL
0 vote314 views1 answer
Prisma transaction
SQL
0 vote287 views1 answer
Sql server union if table exist
SQL
0 vote276 views1 answer
Char varchar nvarchar sql
SQL
0 vote277 views1 answer
Mysql cdn link
SQL
1 vote290 views1 answer
SQL: merging multiple row data in string
SQL
8 votes306 views1 answer
Oracle add auto_increment column to existing table
SQL