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

1 vote265 views1 answer
Sql run multiple updates in one query
SQL
0 vote252 views1 answer
Nueva tabla mysql
SQL
0 vote266 views1 answer
How to add more columns to a table in mysql
SQL
0 vote222 views3 answers
Mysql calculate age from date of birth
SQL
0 vote261 views1 answer
Psql select * from table
SQL
-2 votes288 views3 answers
How to fetch first 10 rows in sql
SQL
2 votes279 views1 answer
How to delete all duplicate items in mysql
SQL
0 vote341 views1 answer
Current month transactions in mysql
SQL
0 vote272 views1 answer
Rails sql query converstion
SQL
0 vote273 views1 answer
Sql select duplicates based on two columns
SQL