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

3 votes172 views2 answers
@sqlresultsetmapping
SQL
1 vote134 views1 answer
Sql run multiple updates in one query
SQL
0 vote144 views2 answers
How to get last inserted id in sql server c#
SQL
4 votes140 views3 answers
Mysql modify foreign key
SQL
6 votes142 views3 answers
Create database mysql utf8
SQL
0 vote93 views2 answers
Avg() sql
SQL
0 vote150 views1 answer
Safe mysql
SQL
2 votes143 views5 answers
Eloquest how to select one specific column in database
SQL
13 votes135 views3 answers
Insert mysql ifile nto database
SQL
0 vote148 views1 answer
ERROR: column "hourly_visitors.hour" must appear in the GROUP BY clause or be used in an aggregate function
SQL