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

0 vote140 views1 answer
How to find date from date table in sql
SQL
4 votes143 views1 answer
Find tables with column name in sql
SQL
0 vote148 views1 answer
Extract sql from query object sqlalchemy
SQL
0 vote137 views1 answer
Postegresql update to null
SQL
0 vote146 views1 answer
Add unique constraint sql server multiple columns
SQL
0 vote107 views1 answer
Hangfire clean script
SQL
0 vote175 views1 answer
Postgres docs /copy metacomand
SQL
1 vote157 views1 answer
Spark sql convert string to date
SQL
0 vote148 views1 answer
Update sqlaclehmy sqlalchemy.orm.evaluator.UnevaluatableError: Cannot evaluate BinaryExpression with operator <function like_op at 0x03CF1DF0>
SQL
1 vote92 views1 answer
Postgres reset auto increment
SQL