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 vote147 views1 answer
Désinstaller postgresql linux
SQL
0 vote141 views1 answer
Csv to sqlite python
SQL
1 vote152 views2 answers
Datetrunc hour snowflake
SQL
1 vote156 views1 answer
Mysql select if empty result
SQL
0 vote151 views2 answers
Script all indexes in a database
SQL
1 vote137 views1 answer
"i_am_a_dummy flag" in MySQL
SQL
0 vote185 views1 answer
Tsql cte in a transaction
SQL
0 vote159 views2 answers
Jsonb
SQL
0 vote169 views1 answer
Except in sql
SQL
1 vote145 views1 answer
Window function mysql
SQL