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 vote184 views2 answers
Postgresql display subquery as json
SQL
17 votes195 views6 answers
Current date in sql
SQL
0 vote267 views1 answer
Sql alter table add column if exists
SQL
1 vote206 views3 answers
How to truncate table with foreign key constraint
SQL
0 vote212 views1 answer
How to find lowest in sql
SQL
1 vote192 views1 answer
Where date = max(date) in sql
SQL
0 vote195 views1 answer
We are intrested to work with your organization
SQL
0 vote201 views1 answer
Mysql db dump restore max file size issue
SQL
19 votes194 views4 answers
Rename database in sql
SQL
0 vote198 views1 answer
Recursive query herarchical data sql server
SQL