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

0 vote133 views1 answer
SQL Query to delete all the tables in a database
SQL
0 vote131 views1 answer
How to find columns with null values in sql
SQL
0 vote130 views1 answer
Mysql query with sql to get the next row
SQL
0 vote147 views1 answer
Dual in db2
SQL
4 votes135 views2 answers
Sql offset
SQL
5 votes141 views4 answers
Change auto increment mysql
SQL
0 vote130 views1 answer
Call object contructor and call methods of object
SQL
1 vote127 views1 answer
Sql eliminare un record
SQL
0 vote148 views1 answer
Check if a column is a primary key in sql server
SQL
5 votes121 views4 answers
Rollback to in sql
SQL