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 vote189 views1 answer
Check user sql password from command line
SQL
3 votes258 views1 answer
Oracle cannot access v$session
SQL
1 vote172 views1 answer
Nested if in mysql
SQL
2 votes182 views1 answer
Oracle kill session by sql_id
SQL
0 vote156 views1 answer
Resolved [java.sql.SQLException: ORA-29977: Unsupported column type for query registration in guaranteed mode ]
SQL
0 vote216 views1 answer
Mysql date without time
SQL
0 vote181 views1 answer
Sql combine results from two tables
SQL
5 votes183 views1 answer
How to use rank function in sql
SQL
0 vote193 views1 answer
Postgres row expiration
SQL
0 vote166 views1 answer
Postgres get running query
SQL