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

5 votes305 views2 answers
How to ascending order in sql
SQL
0 vote164 views10 answers
John the ripper mysql
SQL
1 vote165 views1 answer
Oracle repeat_interval 5 minutes
SQL
5 votes130 views1 answer
Alter table add comment oracle
SQL
0 vote145 views2 answers
Plsql function that return a table
SQL
7 votes155 views3 answers
Can't connect to local mysql server through socket '/tmp/mysql.sock' (2)
SQL
0 vote134 views2 answers
Csv into data postgres
SQL
0 vote168 views1 answer
Query to insert image
SQL
1 vote154 views1 answer
Mysql curdate between two dates
SQL
0 vote158 views1 answer
Mysql conf.d exampel
SQL