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

0 vote428 views1 answer
Get substract count sql
SQL
0 vote361 views1 answer
WHERE not regex in SQL
SQL
0 vote392 views1 answer
Mysql update all record removing 2 hours from column
SQL
1 vote362 views1 answer
Window function mysql
SQL
1 vote306 views1 answer
Postgres reset auto increment
SQL
0 vote374 views2 answers
How to install mssql on mac
SQL
0 vote337 views1 answer
Mysql> grant all privileges on *.* to root@localhost identified by 'password' with grant option;
SQL
0 vote502 views1 answer
Php insert null mysql
SQL
0 vote355 views2 answers
Getting customers with no orders sql
SQL
0 vote360 views1 answer
Unique element in sql
SQL