Synonym oracle

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

3 votes291 views3 answers
C# sql select
SQL
0 vote310 views1 answer
Sql date time query find
SQL
0 vote297 views1 answer
Sql menampilkan data tabel
SQL
0 vote278 views1 answer
Setting default value for Boolean data type in SQL
SQL
-1 vote328 views1 answer
Ms sql select datetime as date
SQL
0 vote300 views1 answer
Mysql page segment
SQL
0 vote320 views1 answer
Create user faunadb
SQL
2 votes286 views2 answers
How to DROP a table in mysql
SQL
2 votes297 views1 answer
Q operator in sql
SQL
13 votes284 views2 answers
Mysql order by multiple columns
SQL