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

2 votes259 views1 answer
Oracle block
SQL
0 vote155 views0 answer
SQL
0 vote198 views1 answer
Postgres multiple left join causing duplicates jsonb_agg
SQL
0 vote207 views2 answers
Select last 30 days sql
SQL
1 vote197 views1 answer
Type int in mysql maxlenght
SQL
0 vote218 views1 answer
Leftjoin in sql
SQL
5 votes206 views1 answer
Sql table columns
SQL
3 votes252 views2 answers
Find string in stored procedure sql server
SQL
0 vote221 views1 answer
Add new column in sql with foreign key
SQL
2 votes137 views1 answer
Select sid oracle
SQL