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

1 vote386 views1 answer
Create email address from first and last name in sql
SQL
0 vote333 views1 answer
Ignore case in string sql
SQL
2 votes329 views2 answers
Select list is not in group by clause
SQL
0 vote277 views1 answer
Check id exist or not in sql
SQL
0 vote351 views1 answer
Transalations from sql to Linq count and group by
SQL
0 vote397 views1 answer
Mysql concatenate select results
SQL
2 votes360 views3 answers
Current setting postgres timezone
SQL
0 vote344 views1 answer
Java nosql sort
SQL
16 votes360 views1 answer
Mysql reset auto increment value
SQL
6 votes351 views3 answers
Oracle all dates between two dates
SQL