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 vote147 views1 answer
How to drop columns with constraint from a table in sql script
SQL
0 vote140 views1 answer
Postgresql get current user name
SQL
0 vote142 views1 answer
SQL column name Oracle
SQL
0 vote163 views1 answer
Oracle job schedules
SQL
0 vote162 views2 answers
Import .sql into postgres db command
SQL
2 votes144 views1 answer
Plsql block
SQL
0 vote139 views1 answer
Incorrect datetime value sql table error 1292
SQL
0 vote154 views1 answer
Oracle merge insert if not exists
SQL
29 votes145 views5 answers
Mysql show table structure
SQL
25 votes167 views4 answers
Metadata
SQL