Oracle 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;

SELECT * FROM DBA_SYNONYMS WHERE SYNONYM_NAME = 'synonym_name';

Synonym oracle

CREATE OR REPLACE PUBLIC SYNONYM suppliers FOR app.suppliers;

Similar codes

0 vote153 views1 answer
Updating database in sql
SQL
0 vote112 views1 answer
Can we rollback data that are deleted using DELETE
SQL
1 vote112 views1 answer
Mysql print variable
SQL
0 vote108 views1 answer
Match end of string regex sql
SQL
2 votes105 views1 answer
Sqlite insert if not exists
SQL
8 votes116 views1 answer
Mysql restore database
SQL
6 votes156 views2 answers
Database url postgres
SQL
0 vote117 views1 answer
Mysql join column order By and group By
SQL
0 vote96 views1 answer
Check duplicate values plsql
SQL
0 vote112 views1 answer
Mysql group by derived column
SQL