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 vote262 views1 answer
Sql table to store status
SQL
0 vote315 views1 answer
How to put 0 or 000 depending IDCustomer length in sql server
SQL
1 vote391 views1 answer
Mysql get max value and id
SQL
13 votes326 views2 answers
Sqlite rename table
SQL
0 vote324 views1 answer
Incorrect string value: mysql
SQL
0 vote272 views1 answer
Query for maximum salary
SQL
2 votes330 views4 answers
Mysql get all tables row count
SQL
0 vote291 views1 answer
Postgresql newline character
SQL
0 vote317 views2 answers
How to know the character set of an oracle databes
SQL
5 votes308 views2 answers
Oracle show procedures
SQL