Oracle synonym procedure

-- Can be a table, package, procedure...
CREATE OR REPLACE SYNONYM syn_name FOR my_schema.my_procedure;      
CREATE OR REPLACE PUBLIC SYNONYM syn_name FOR my_schema.my_procedure;

-- Through a dblink:
CREATE OR REPLACE SYNONYM syn_name FOR my_schema.my_procedure@my_dblink;

Similar codes

0 vote135 views1 answer
Data structures in sql
SQL
2 votes177 views2 answers
Postgres change owner of schema
SQL
0 vote140 views1 answer
Big table in mysql
SQL
11 votes209 views1 answer
Oracle insert from select
SQL
0 vote146 views1 answer
Mysql concatenate select results
SQL
9 votes133 views4 answers
SQL Date Format
SQL
0 vote140 views1 answer
Get last three characters in mysql column
SQL
0 vote140 views1 answer
Oracle drop type
SQL
0 vote133 views1 answer
How to export table data from mysql table in sql format
SQL
24 votes144 views5 answers
Import dump mysql
SQL