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

4 votes212 views1 answer
Update table from another table oracle
SQL
0 vote219 views1 answer
Mysql into outfile with headers
SQL
3 votes227 views2 answers
Sql get month name
SQL
0 vote228 views1 answer
System.Data.SqlClient.SqlException: 'Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding.' SqlDataAdapter
SQL
4 votes259 views2 answers
Postgresql float data type
SQL
1 vote238 views1 answer
Sql not equal multiple columns
SQL
0 vote226 views3 answers
Postgresql allow remote connections
SQL
2 votes225 views1 answer
Anonymous block plsql
SQL
0 vote222 views1 answer
Count the table indatabase
SQL
0 vote242 views1 answer
Postgres row expiration
SQL