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 vote301 views1 answer
Contraint default SQL
SQL
0 vote196 views1 answer
Concatenate columns in table
SQL
0 vote201 views1 answer
Mysql beautifier terminla
SQL
1 vote212 views2 answers
Mysql switch case
SQL
17 votes274 views6 answers
Sql current date
SQL
37 votes421 views3 answers
Sql check duplicate value in column
SQL
0 vote218 views1 answer
Oracle list subpartitions
SQL
16 votes206 views6 answers
This is incompatible with sql_mode=only_full_group_by
SQL
0 vote294 views1 answer
SQL check if record exist
SQL
0 vote196 views1 answer
Uuid sqlalcomany
SQL