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 vote399 views1 answer
Mysql relationships between tables
SQL
1 vote358 views1 answer
Change old domain to new domain name wordpress
SQL
-1 vote354 views1 answer
Mysql change database charset and collation
SQL
2 votes383 views3 answers
Sql server reseed identity column
SQL
5 votes344 views3 answers
String concatenation sql server
SQL
18 votes347 views6 answers
Mysql create table
SQL
0 vote362 views1 answer
Apache Derby: Create SQL Dump with data
SQL
0 vote385 views1 answer
Oracle current timestamp insert statement
SQL
2 votes331 views2 answers
Mysql all columns
SQL
0 vote515 views1 answer
ORA-01400
SQL