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 votes292 views1 answer
Convert sqlite table to pandas dataframe
SQL
1 vote307 views1 answer
Python clean sql string
SQL
1 vote297 views2 answers
Sql groub by count
SQL
0 vote303 views1 answer
What is ssrs and ssis in sql server
SQL
0 vote327 views1 answer
Shows all databases created by user in ms sql
SQL
12 votes339 views1 answer
Run mysql instance in docker
SQL
0 vote288 views2 answers
Mysql disable foreign key checks
SQL
0 vote320 views1 answer
Basic structure of sql expression having clause
SQL
0 vote283 views1 answer
Wordpress sql find and replace
SQL
0 vote297 views1 answer
Original Query
SQL