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 vote111 views1 answer
Sql how to get courses that i have made prerequisites
SQL
0 vote99 views1 answer
Carbon mysql d m y to y-m-d
SQL
0 vote110 views1 answer
Drop a field in psql django
SQL
3 votes114 views1 answer
Sql multi column index performance
SQL
2 votes110 views1 answer
Oracle apex list connected users
SQL
0 vote119 views1 answer
Neo4j command to run script file
SQL
0 vote143 views1 answer
Error Code: 1267. Illegal mix of collations (latin1_general_ci,IMPLICIT) and (latin1_swedish_ci,IMPLICIT) for operation '=' 0.000 sec
SQL
0 vote156 views1 answer
Contraint default SQL
SQL
6 votes102 views2 answers
Oracle
SQL
0 vote110 views1 answer
Drop-toys-table
SQL