/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 votes143 views1 answer
How to search table name in stored procedure in sql server
SQL
0 vote144 views1 answer
T-SQL Never ending DELETE
SQL
2 votes142 views1 answer
Oracle virtual column
SQL
0 vote159 views1 answer
Mariadb.service failed with result 'exit-code'
SQL
13 votes152 views11 answers
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysql.sock' (2) Ask
SQL
0 vote144 views1 answer
Find all tables where column name exists oracle
SQL
0 vote156 views1 answer
Drop column from table if exist on live server mysql
SQL
0 vote144 views2 answers
Postgres another version
SQL
3 votes135 views1 answer
Search for column name in psql
SQL
4 votes154 views2 answers
Bulk kill mysql processlist
SQL