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 vote218 views1 answer
Capture Image Store Image in Folder and image Path in sqlite Database
SQL
0 vote221 views2 answers
Postgres show current role
SQL
6 votes267 views2 answers
Oracle compile trigger
SQL
0 vote207 views1 answer
Back up stored procedures mysql
SQL
0 vote207 views1 answer
How to avoid duplicate records in sqlite
SQL
0 vote213 views1 answer
Syntax for changing column size in mysql
SQL
0 vote214 views1 answer
Call rest api from postgresql
SQL
0 vote226 views1 answer
Add multiple field in table sql
SQL
0 vote225 views1 answer
Change magento database url usimg musql
SQL
0 vote212 views1 answer
Sql server convert date to weekday
SQL