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

1 vote306 views2 answers
Foreign key set 0
SQL
0 vote279 views3 answers
ChAnge TABLE name apex oracle
SQL
0 vote282 views1 answer
Error-expression-select-list-not-group-by-nonaggregated-column/
SQL
8 votes310 views1 answer
Oracle search text in all packages
SQL
6 votes270 views1 answer
How to count number of rows in sql
SQL
1 vote270 views1 answer
Postgres get timestamp
SQL
4 votes277 views1 answer
Restart for pg_hba.conf file
SQL
8 votes305 views2 answers
Oracle undo usage
SQL
5 votes284 views1 answer
Oracle create table comment
SQL
0 vote299 views1 answer
Delete record by id sql
SQL