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

14 votes269 views1 answer
Excel is not a database
SQL
0 vote255 views1 answer
Backup a table in sql
SQL
0 vote280 views1 answer
Mysql 1 hour ago
SQL
0 vote262 views1 answer
Drop all tables in azure sql database
SQL
0 vote272 views1 answer
Fetcht he leftmost word in a comma separated string in sql
SQL
2 votes224 views1 answer
Sql view column data type
SQL
1 vote293 views2 answers
Extract weekday from date in sql
SQL
0 vote286 views1 answer
Can we rollback in sql
SQL
0 vote284 views1 answer
Hoq to import database source
SQL
0 vote294 views1 answer
Openquery update linked server
SQL