/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

5 votes118 views1 answer
Purge undo tablespace usage
SQL
0 vote120 views1 answer
Sqlserver now
SQL
0 vote117 views1 answer
List MySQL Table and Index Size
SQL
1 vote109 views1 answer
Real world example of nosql
SQL
0 vote115 views1 answer
Table or view does not exist
SQL
1 vote114 views1 answer
Drop df constraint sql server
SQL
0 vote136 views1 answer
T-sql delete view if exists
SQL
0 vote117 views1 answer
Mysql add text to existing field
SQL
0 vote133 views1 answer
Error code 1451 sql
SQL
1 vote123 views1 answer
Oracle previous year
SQL