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 vote235 views1 answer
Time data type in mysql
SQL
0 vote204 views1 answer
Sql server delete records with specific date
SQL
1 vote215 views1 answer
Sql convert month name to number
SQL
1 vote226 views1 answer
Oracle undo usage per session
SQL
0 vote237 views1 answer
Nvl2 syntax
SQL
1 vote213 views1 answer
Psql connections
SQL
0 vote212 views2 answers
Sql server select first day of previous year
SQL
0 vote218 views1 answer
Postgresql check total storage
SQL
2 votes238 views2 answers
Postgres change owner of schema
SQL
10 votes216 views1 answer
Create table oracle
SQL