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

10 votes273 views1 answer
Oracle all_dependencies
SQL
1 vote274 views1 answer
Duplicating a MySQL table with all the data Command
SQL
0 vote292 views1 answer
Allow null in psql
SQL
-1 vote301 views1 answer
Mysql faster insert
SQL
0 vote315 views1 answer
Eliminate zero from integer mysql
SQL
1 vote252 views1 answer
Reutrn string after character sql
SQL
0 vote282 views1 answer
Sql server: concatinate column value without trailing or leading comma
SQL
0 vote324 views1 answer
Error Code: 1267. Illegal mix of collations (latin1_general_ci,IMPLICIT) and (latin1_swedish_ci,IMPLICIT) for operation '=' 0.000 sec
SQL
0 vote258 views1 answer
Mysql update sequence with order by
SQL
1 vote244 views3 answers
Remove unique key from a table
SQL