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 vote298 views1 answer
How to insert multiple values in a single column in sql
SQL
3 votes282 views2 answers
Oracle drop column
SQL
4 votes291 views1 answer
Search column by name mysql
SQL
8 votes277 views3 answers
Postgres connection string
SQL
0 vote287 views1 answer
Like sql for second letter of the family name
SQL
0 vote277 views1 answer
Liquibase update row
SQL
0 vote283 views1 answer
Fatal error: Uncaught PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'autos_id' in 'field list' in
SQL
7 votes302 views2 answers
Where keyword sql
SQL
1 vote271 views1 answer
Oracle index partition
SQL
0 vote280 views1 answer
Using distinct and count together in sql
SQL