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 vote256 views1 answer
How to fetch data from database in sql
SQL
0 vote232 views1 answer
Print hello world in plsql
SQL
1 vote237 views1 answer
Describe table in sql
SQL
7 votes258 views2 answers
Phpmyadmin change password
SQL
-1 vote221 views1 answer
Convert google analytics dathourminute to time stamp? sql
SQL
0 vote233 views1 answer
Postgres type equivalent to timespan c#
SQL
0 vote259 views1 answer
Python mysql check if database exists
SQL
0 vote243 views1 answer
Alter table engine mysql
SQL
23 votes236 views6 answers
How to create table in sql
SQL
15 votes219 views2 answers
Open postgress in terminal mac
SQL