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 votes182 views1 answer
SELECT LOCKED FROM public.databasechangeloglock WHERE ID=1
SQL
1 vote201 views3 answers
How to create a table structure from another table in mysql
SQL
7 votes185 views1 answer
Sql limit decimal places
SQL
0 vote159 views1 answer
Mysql multiple count
SQL
0 vote125 views1 answer
Select all domains of database firbird
SQL
0 vote163 views4 answers
First max salary in sql
SQL
4 votes162 views4 answers
Print pl sql
SQL
1 vote129 views1 answer
Database run
SQL
0 vote168 views1 answer
How to add session data into mysql database from button
SQL
0 vote230 views1 answer
Oracle create package specification
SQL