Oracle create synonym

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

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

Synonym oracle

CREATE OR REPLACE PUBLIC SYNONYM suppliers FOR app.suppliers;

Similar codes

6 votes213 views2 answers
Install psql mac
SQL
8 votes189 views1 answer
Racle create auto increment column
SQL
1 vote207 views1 answer
Ora-01950 no privileges on tablespace
SQL
0 vote191 views1 answer
Check database restore status sql script
SQL
0 vote191 views1 answer
Sql server rtrim everything after character
SQL
5 votes164 views1 answer
Sql use database
SQL
0 vote146 views1 answer
Sql gather statistics to increase performance
SQL
1 vote149 views1 answer
Local sql server
SQL
-1 vote149 views1 answer
Ssms connect with connection string
SQL
0 vote164 views1 answer
Mysql workbench procedure
SQL