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 vote317 views1 answer
Sql with example
SQL
1 vote299 views1 answer
Write an SQL query to print details of the Workers whose FIRST_NAME ends with ‘h’ and contains six alphabets.
SQL
0 vote310 views1 answer
Flask sqlalchemy. commit does not save changes
SQL
1 vote275 views1 answer
Temp table vs variable table in sql server
SQL
3 votes289 views1 answer
RENAME table pl sql
SQL
0 vote298 views1 answer
Plpgsql raise notice
SQL
0 vote286 views1 answer
Sql server select furst day of current year
SQL
1 vote287 views1 answer
How to delete a record from sqlite in android
SQL
2 votes238 views1 answer
Oracle current date without time
SQL
0 vote302 views1 answer
Trigger stock phpmyadmin
SQL