Oracle create 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;

Synonym oracle

CREATE OR REPLACE PUBLIC SYNONYM suppliers FOR app.suppliers;

Similar codes

50 votes316 views4 answers
Sql alter type of column
SQL
0 vote277 views2 answers
.... ERROR! The server quit without updating PID file mysql centos
SQL
21 votes255 views3 answers
Sql average
SQL
7 votes239 views1 answer
Append column sql
SQL
0 vote268 views1 answer
Create dump file mysql workbench
SQL
1 vote259 views1 answer
Last 6 months postgresql
SQL
0 vote334 views1 answer
Current month transactions in mysql
SQL
3 votes272 views2 answers
Postgres inner join vs join
SQL
0 vote246 views1 answer
Fix sqlite3 ruby on rails
SQL
0 vote272 views1 answer
Sql server get date of previous sunday
SQL