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 vote212 views1 answer
R write csv without index
SQL
6 votes188 views1 answer
How to count number of rows in sql
SQL
1 vote249 views4 answers
How to check table in postgresql from terminal
SQL
0 vote200 views1 answer
Mysql remove last character
SQL
0 vote186 views1 answer
If null don't update
SQL
0 vote215 views1 answer
Mssql unique key accept nulls
SQL
0 vote202 views1 answer
Jdbc sql connection string
SQL
8 votes205 views1 answer
Oracle tablespace datafile max size
SQL
0 vote206 views1 answer
How to combine first and last nae into one columb sql
SQL
1 vote188 views1 answer
Postgres count string length
SQL