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

7 votes132 views1 answer
Query delete duplicates
SQL
0 vote136 views2 answers
Sql query print strings and int
SQL
0 vote114 views1 answer
Alter table add column in SQL Server- NAYCode.com
SQL
0 vote156 views1 answer
Tsql cte in a transaction
SQL
2 votes115 views2 answers
Spring import sql
SQL
0 vote125 views1 answer
Oracle table privileges
SQL
0 vote115 views1 answer
Should I use the datetime or timestamp data type in MySQL?
SQL
0 vote123 views1 answer
Test the postgresql db connection
SQL
7 votes117 views4 answers
Lowest salary in sql
SQL
0 vote136 views1 answer
Create query in where clasue
SQL