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

244 votes459 views14 answers
Sql n insert
SQL
0 vote164 views1 answer
Sql find leading space
SQL
4 votes174 views5 answers
Primary key
SQL
0 vote165 views1 answer
Select other columns with distinct
SQL
0 vote164 views1 answer
Mysql case when on date
SQL
0 vote201 views2 answers
Clauses in mysql
SQL
0 vote151 views1 answer
Cara menampilkan user di mysql terminal
SQL
9 votes182 views6 answers
Sql add column with default value
SQL
1 vote193 views1 answer
Mysql view current queries
SQL
3 votes201 views3 answers
Order by postgres
SQL