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 vote348 views1 answer
Number(10 2) in sql means
SQL
0 vote476 views1 answer
Reset a table's identity column and remove test records
SQL
0 vote362 views2 answers
Mysql on update current_timestamp
SQL
0 vote385 views1 answer
Mysql url
SQL
0 vote364 views1 answer
Hour differeence in mysql
SQL
0 vote378 views2 answers
Generate sql trigger through ef migration
SQL
1 vote378 views1 answer
Connect to mysql database ubuntu
SQL
14 votes360 views3 answers
Sql trim from string
SQL
0 vote390 views1 answer
How do you insert boolean to postgresql
SQL
0 vote346 views1 answer
Mysql count by month
SQL