/SQL/Create synonym for dblink in oracle

Create synonym for dblink in oracle

-- Can be a table, package, procedure...
CREATE OR REPLACE SYNONYM syn_name FOR my_schema.my_table@my_dblink;
CREATE OR REPLACE SYNONYM syn_name FOR my_schema.my_procedure@my_dblink;
CREATE OR REPLACE SYNONYM syn_name FOR my_schema.my_package@my_dblink;

Similar codes

2 votes154 views2 answers
Checking data type in sql server
SQL
0 vote127 views1 answer
Oracle create package body
SQL
0 vote105 views1 answer
Connection error in mysql workbench
SQL
2 votes132 views1 answer
Match in sql server
SQL
0 vote146 views1 answer
Oracle query to find schema you are working on
SQL
0 vote142 views1 answer
Mysql Digital Ocean connection problems
SQL
0 vote132 views1 answer
Get number of rows in every table mysql
SQL
36 votes259 views6 answers
Change column data type sql
SQL
15 votes145 views2 answers
Sql order by multiple columns
SQL
1 vote153 views1 answer
Mysql select and count left join
SQL